SYNTAX FOR GROUP HAVING ORDER BY
Jump to navigation
Jump to search
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