Advertisements
Advertisements
प्रश्न
What is the purpose of the following clauses in a select statement?
HAVING
लघु उत्तर
Advertisements
उत्तर
In an SQL select statement, the HAVING clause is used to filter groups of rows created by the GROUP BY clause.
It acts just like a WHERE clause, but with one critical difference: WHERE filters individual rows before grouping, while HAVING filters aggregate groups after grouping.
shaalaa.com
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 1: Querying and SQL Functions - Exercise [पृष्ठ २३]
