SQL GROUP BY- NEED and USES

What are SQL joins?

SQL GROUP BY is used to group rows with similar values for aggregate functions. Without GROUP BY user cannot use aggregate functions.

Syntax:

SELECT AGGREGATE(COL)
FROM demo_tab
GROUP BY col_name;

SELECT DEPT_NAME, AVG(SALARY)
FROM EMPLOYEE
GROUP BY DEPT_NAME;

Now lets use GROUP BY with HAVING

SELECT DEPT_NAME, AVG(SALARY)
FROM EMPLOYEE
GROUP BY DEPT_NAME
HAVING AVG(SALARY) > 4000 ;

Thanks For Reading!

Related Posts