In this case you can add an id field which acts like a row number. Then you can use the following query
select * from mytable where id between 1 and 10
It will return top 10 rows
Hope this will work
All the Best
With Regards
Vijay. R|||SQL server 2003 ?