剛弄明白,來發一貼:-- 我們想把最先進入公司的5個人找出來 SELECT * FROM emp WHERE ROWNUM <= 5 ORDER BY hiredate; 或 SELECT * FROM (SELECT * FROM emp ORDER BY hiredate) WHERE ROWNUM <= 5;-- 我們想把最先進入公司的6~10個人找出來!!!!!!!!!!!!!! SELECT * FROM (SELECT * FROM emp ORDER BY hiredate) WHERE ROWNUM <= 10 MINUS SELECT * FROM (SELECT * FROM emp ORDER BY hiredate) WHERE ROWNUM <= 5;Good luck!!
select * from tablename where rownnum<N+1;
SELECT * FROM emp WHERE ROWNUM <= 5 ORDER BY hiredate;
或
SELECT * FROM (SELECT * FROM emp ORDER BY hiredate)
WHERE ROWNUM <= 5;-- 我們想把最先進入公司的6~10個人找出來!!!!!!!!!!!!!!
SELECT * FROM (SELECT * FROM emp ORDER BY hiredate)
WHERE ROWNUM <= 10
MINUS
SELECT * FROM (SELECT * FROM emp ORDER BY hiredate)
WHERE ROWNUM <= 5;Good luck!!