如何得到从第M条到第N条的记录[按照某种方式排序]
在oracle 8i以上的版本,可以使用如何语句来实现:
select empno,ename,rowcount from ( select t.empno,t.ename,(row_number() over(order by t.empno asc)) as rownumber,(count(*) over()) as rowcount from emp t) sorted_t where sorted_t.rownumber between m and n order by sorted_t.empno
在oracle 8i以上的版本,可以使用如何语句来实现:
select empno,ename,rowcount from ( select t.empno,t.ename,(row_number() over(order by t.empno asc)) as rownumber,(count(*) over()) as rowcount from emp t) sorted_t where sorted_t.rownumber between m and n order by sorted_t.empno