SQL> SELECT * FROM TEST2;
NUM NAME SAL
---- -------- ----------
10 AAA 100000
20 BBB 200000
30 CCC 300000
40 DDD
SQL> SELECT AVG(SAL) FROM TEST2;
AVG(SAL)
----------
200000
SQL> SELECT COUNT(SAL),COUNT(*) FROM TEST2;
COUNT(SAL) COUNT(*)
---------- ----------
3 4
SQL> SELECT SUM(SAL) FROM TEST2;
SUM(SAL)
----------
600000
|