某廢柴的廢棄日記

Miss終於講左答案......
真係淺到我諗唔到喎.....
SQL啊, 我敗給祢了 ◯￨￣￨＿

SQL> SELECT DISTINCT e.empno,e.ename,e.sal,se.empno,se.ename,se.sal FROM EMP e, EMP se
  2  WHERE e.sal = se.sal
  3  AND e.empno < se.empno;

     EMPNO ENAME             SAL      EMPNO ENAME             SAL
---------- ---------- ---------- ---------- ---------- ----------
      7521 WARD             1250       7654 MARTIN           1250
      7788 SCOTT            3000       7902 FORD             3000

SQL>

標籤： Software