Use the Top function to query only the top 10 rows. Syntax is as below:
Select top 10 * from schemaname.tablename order by columnname desc;
To view any 10 rows of a table:
Select top 10 * from schemaname.tablename; or Select * from schemaname.tablename limit 10;