그룹 결과 제한 - HAVING 사용

SELECT deptno, max(sal) FROM emp

GROUP BY deptno HAVING max(sal) > = 2900;

 

 

SELECT job, SUM(sal) FROM emp WHERE job<>'SALESMAN'
GROUP BY job HAVING SUM(sal)>5000
ORDER BY SUM(sal);