• Use Top clause without order by clause.

    Select top 10 columnname from yourtable.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server