#Lec30
This video is very useful for all students who are preparing for the exams like(like GATE, NTA NET, NIELIT, PSU, DSSSB, KVS, Htet).
Lecture by Nagarajan.S
HAVING Clause
The MySQL HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE.
Syntax
The syntax for the HAVING Clause in MySQL is:
SELECT expression1, expression2, ... expression_n,
aggregate_function (expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n
HAVING condition;