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...