SQL分页获取数据

SQL Server分页

select * from 
(select row_number() over(order by MaterialNM) as rowId, * from MDMMaterials where EditState='0') t
where rowId between 1 and 100

Oracle分页

SELECT * FROM 
(SELECT rownum AS rn,MaterialNM,EditState FROM MDMMaterials WHERE EditState='0' ORDER BY MaterialNM) t
WHERE rn BETWEEN 1 AND 100

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/zhchsh/p/5461480.html