오라클 DB | sum, count, avg, max, min

 

합계: sum()

SQL>select sum(sal) from emp; 

 

 

평균 : avg()

SQL> select avg(sal) from emp;

 

 

카운트: count()

SQL>select count(*) from emp;

 

 

최대값 : max()

SQL>select max(sal) from emp;

 

 

 

최소값 : min()

SQL>select min(sal) from emp;