Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
294 views
in Structured Query Language (SQL) by (54.8k points)
closed by

Write note on having clause?

1 Answer

+1 vote
by (49.1k points)
selected by
 
Best answer

HAVING clause: 

The HAVING clause can be used along with GROUP BY clause in the SELECT statement to place condition on groups and can include aggregate functions on them.

For example to count the number of Male and Female students belonging to Chennai.

SELECT gender, COUNT(*) FROM Student GROUP BY Gender HAVING Place = ‘Chennai’;

Gender Count(*)
M 2
F 2

The above output shows the number of Male and Female students in Chennai from the table student.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...