SQL分页获取数据

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
上一篇:使用EasyNetQ组件操作RabbitMQ消息队列服务


下一篇:rabbitMQ消息队列原理