select * from(select *,row_number()over(ORDER BY table.columnName ) as num from table) as t WHERE t.num>=1 and t.num<=10