Oracle/MySql/SqlServer数据库分页

Oracle 1、rownum select * from ( select rownum rn,* from emp where sj >='2018-03-01' and sj <= '2018-03-31' and rownum<=pageNum*pageSize ) emprn where emprn>=(pageNum-1)*pageSize 2、row_number() over() select * from ( select row_num...
oracle | 2018-04-12 08:33 | 阅读 1454 次 | 评论 0 条