on SQL Server,

you can used function row_number() over (..) bellow example:

select ROW_NUMBER() OVER ( order by column_name ) as myrow, column1, column2, … from TEST1 where myrow between 5 and 10 ;

note: column_name is column that you need to order.

see more detail at

Blog IT Knowledge Indy : SQL Tips

http://blogitknowledge.u-indy.com/database-services/sql-tips/sql-tips-how-to-limiting-result-rows-many-databases/