SQL> SELECT * FROM TEST2;
NUM NAME SAL
---------- -------------------- ----------
10 AAA 100000
20 BBB 200000
30 CCC 300000
40 DDD
50 AAA 150000
60 CCC 250000
70 DDD 350000
7行が選択されました。
SQL> SELECT SUM(SAL),NAME
2 FROM TEST2
3 GROUP BY NAME
4 ORDER BY 2;
SUM(SAL) NAME
---------- --------------------
250000 AAA
200000 BBB
550000 CCC
350000 DDD
SQL> SELECT SUM(SAL),NAME
FROM TEST2
GROUP BY NAME
HAVING SUM(SAL)>500000
ORDER BY 2;
SUM(SAL) NAME
---------- --------------------
550000 CCC
SQL>
|