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 [पृष्ठ २३]
