假设有表TableA,字段为FieldA, FieldB,查询第10到20条记录,SQL如下:
select * from
( select row_number() over(order by FieldA) as RowNum, * from TableA ) t
where t.RowNum between 10 and 20
select * from
( select row_number() over(order by FieldA) as RowNum, * from TableA ) t
where t.RowNum between 10 and 20