行号rownum问题，以及相关子查询

SQL> –第一题 行号 rownum(伪列)
SQL> select rownum,empno,ename,sal
2 from emp;

ROWNUM      EMPNO ENAME        SAL                                                                                  

---

     1       7369 SMITH        800                                                                                  
     2       7499 ALLEN       1600                                                                                  
     3       7521 WARD        1250                                                                                  
     4       7566 JONES       2975                                                                                  
     5       7654 MARTIN      1250                                                                                  
     6       7698 BLAKE       2850                                                                                  
     7       7782 CLARK       2450                                                                                  
     8       7788 SCOTT       3000                                                                                  
     9       7839 KING        5000                                                                                  
    10       7844 TURNER      1500                                                                                  
    11       7876 ADAMS       1100                                                                                  

ROWNUM      EMPNO ENAME        SAL                                                                                  

---

    12       7900 JAMES        950                                                                                  
    13       7902 FORD        3000                                                                                  
    14       7934 MILLER      1300                                                                                  

已选择14行。

SQL> select rownum,empno,ename,sal
2 from emp
3 where rownum<=3
4 order by sal desc;

ROWNUM      EMPNO ENAME        SAL                                                                                  

---

     2       7499 ALLEN       1600                                                                                  
     3       7521 WARD        1250