摘要： 假设有表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 阅读全文