Aggregate function in SQL (Count,Sum,Max,Min,Avg)

 

SQL> select fname,lname,salary,dno,super_ssn
2 from employee;
FNAME LNAME SALARY DNO
---------------- -------------------- ---------- ----------
SUPER_SSN
--------------------
Varun deva 15000 1
1230
prjwal raj 14500 2
1240
pranav naik 14000 3
1250

FNAME LNAME SALARY DNO
--------------- -------------------- ---------- ----------
SUPER_SSN
--------------------
Thilak naik 15000 4
1260

SQL> select sum(salary),max(salary),min(salary),avg(salary),count(salary)
2 from employee;
SUM(SALARY) MAX(SALARY) MIN(SALARY) AVG(SALARY)
COUNT(SALARY)
----------- ----------- ----------- ----------- -------------
58500 15000 14000 14625 4