select * from
(
select *, ROW_NUMBER() OVER (order by OrderColumn desc) as Pos from table_Name
WHERE where_condition ) as T
where T.Pos > 10 and T.Pos <= 20
取10-20條記錄
select * from
(
select *, ROW_NUMBER() OVER (order by OrderColumn desc) as Pos from table_Name
WHERE where_condition ) as T
where T.Pos > 10 and T.Pos <= 20
取10-20條記錄