0 votes
2.7k views
in General by (35.7k points)
closed by

Aryan, a database administrator, has grouped records of a table with the help of group by clause.

He needs to further filter groups of records generated through group by clause. 

Suggest suitable clause for it and properly explain its usage with the help of an example.

1 Answer

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

Having clause is used to further filter those groups of records which will be generated through group by clause. 

For example: 

Select max(marks) from student group by classes having classes in (10,12); 

Above given query will arrange records in groups according to the classes. Further filtering on these groups will happen through having clause, which will finally display the highest marks from classes 10 and 12.

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.

Categories

...