老师这样不是也可以么？

源自：5-2 案例1

老师这样不是也可以么？

select rownum, r,empno,ename,sal
from(select rownum r,empno,ename,sal from emp where rownum <=8 order by sal desc )e1
where r>=5;

提问者：wearksidy_yxp 2015-08-24 09:47

个回答

慕粉2349237414

2016-11-07 16:37:21

这个分页有点难，听不懂的感觉

0
Jery227

2015-11-20 04:24:24

SELECT * FROM (SELECT ROWNUM rNUM,e.* FROM (SELECT * FROM emp ORDER BY sal DESC) e)
WHERE rNUM>=5 AND rNUM<=8

0
wearksidy_yxp

2015-08-24 09:59:29

测完之后懂了，thx~

0