SQL Server分页
select * from
(select row_number() over(order by MaterialNM) as rowId, * from MDMMaterials where EditState='') t
where rowId between 1 and 100
Oracle分页
SELECT * FROM
(SELECT rownum AS rn,MaterialNM,EditState FROM MDMMaterials WHERE EditState='' ORDER BY MaterialNM) t
WHERE rn BETWEEN 1 AND 100