SYNTAX FOR GROUP HAVING ORDER BY

SELECT ... AGRIGATEDFUNCTION()
FROM TABLE1, ...
WHERE < CONDITION>
GROUP BY COL1, COL2...
HAVING <AGG>
ORDER BY

THE HAVING CLAUSE ACTS ON AGG FUNCTIONS AND FILTERING GROUP BY OUTPUP

' FIND SALARY BASED ON EACH DEPARTMENT NUMBER NOTE: THE SAME COLUMN USED THE THE SELECT STATEMENT "DEPTNO" SHOULD BE USED IN THE GROUP BY

SELECT DEPTNO, SUB(SALARY) "TOTAL SALARY"
FROM EMP
GROUP BY DEPTNO

DISPLAY THE NUMBER OF MALES AND FEMALES FROM EACH CITY ' TABLE > CUST > COLUMN GENDER, CITY

SELECT CITY, GENDER, COUNT(*) "NUMBER OF CUSTOMERS"
FROM CUST
GROUP BY CITY, GENDER

FIND NUMBER OF EMPLOYEES BASED ON EMPLOYEES BASED ON DEPTNO UNDER EACH DEPTNO JOBOFEMPLOYEE AND HAVING MORE THAN 3 COUNTS

SELECT DEPTNO, JOBOFEMPLOYEE, COUNT(*)
FROM EMP
GROUP BY DEPTNO, JOBOFEMPLOYEE
ORDER BY DEPTNO
HAVING COUNT(*) >=3
ORDER BY DEPTNO

Back To Top- Home - Category