SYNTAX FOR GROUP HAVING ORDER BY - Revision history

Bacchas at 22:29, 18 November 2017

2017-11-18T22:29:07Z

← Older revision		Revision as of 22:29, 18 November 2017
Line 5:		Line 5:
	HAVING <AGG>		HAVING <AGG>
	ORDER BY</PRE>		ORDER BY</PRE>
			''' THE HAVING CLAUSE ACTS ON AGG FUNCTIONS AND FILTERING GROUP BY OUTPUP'''

	'''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER'''		'''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER'''
Line 25:		Line 26:
	GROUP BY DEPTNO, JOBOFEMPLOYEE		GROUP BY DEPTNO, JOBOFEMPLOYEE
	ORDER BY DEPTNO		ORDER BY DEPTNO
			HAVING COUNT(*) >=3
			ORDER BY DEPTNO

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 22:26, 18 November 2017

2017-11-18T22:26:04Z

← Older revision		Revision as of 22:26, 18 November 2017
Line 1:		Line 1:
	SELECT ... AGRIGATEDFUNCTION()		<PRE>SELECT ... AGRIGATEDFUNCTION()
	FROM TABLE1, ...		FROM TABLE1, ...
	WHERE < CONDITION>		WHERE < CONDITION>
	GROUP BY COL1, COL2...		GROUP BY COL1, COL2...
	HAVING <AGG>		HAVING <AGG>
	ORDER BY		ORDER BY</PRE>

	'''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER'''		'''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER'''

Bacchas at 22:25, 18 November 2017

2017-11-18T22:25:26Z

← Older revision		Revision as of 22:25, 18 November 2017
Line 19:		Line 19:
	GROUP BY CITY, GENDER		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


	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 22:18, 18 November 2017

2017-11-18T22:18:40Z

← Older revision		Revision as of 22:18, 18 November 2017
Line 18:		Line 18:
	FROM CUST		FROM CUST
	GROUP BY CITY, GENDER		GROUP BY CITY, GENDER


			[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "SELECT ... AGRIGATEDFUNCTION() FROM TABLE1, ... WHERE < CONDITION> GROUP BY COL1, COL2... HAVING ORDER BY '''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER''' NOTE: THE..."

2017-11-18T22:17:34Z

Created page with "SELECT ... AGRIGATEDFUNCTION() FROM TABLE1, ... WHERE < CONDITION> GROUP BY COL1, COL2... HAVING <AGG> ORDER BY '''' FIND SALARY BASED ON EACH DEPARTMENT NUMBER''' NOTE: THE..."

New page

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

'''' 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