Paging:
One method:
WITH OrderedOrders AS (SELECT *,ROW_NUMBER() OVER (order by [id])as RowNumber FROM table_info )
SELECT * FROM OrderedOrders
WHERE RowNumber between 10 and 20;
the other method:
SELECT * FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTable
where rowNum between 10 and 20;