SQL高效分页

Select * from(select *,Row_Number() over(order by saveTime) rownum from
MachineData)t where t.rownum > 11 and t.rownum <= 20

就是这句话了。

Select * from(select *,Row_Number() over(order by saveTime desc) rownum from
MachineData where machine_id='211')t where t.rownum > 1111 and t.rownum <= 1121