SQL HAVING GROUP BY Clause

A “HAVING” Clause is use to filter a records using “GROUP BY” Clause and without GROUP BY clause, the HAVING work like a WHERE clause. Only the groups that meet the HAVING criteria will be returned.

According to Wikipedia,

A “HAVING” clause in SQL specifies that an SQL SELECT statement should only return rows where aggregate values meet the specified conditions.

Stayed Informed - 37 Best SQL Server Interview Questions and Answers

Syntax:-

SELECT columnName  FROM TableName
     WHERE condition  GROUP BY columnName
HAVING condition

--WITH ORDER BY:-
SELECT columnName FROM TableName
   WHERE condition GROUP BY columnName
HAVING condition
ORDER BY columnName

Examples:-

SELECT COUNT(Id) AS Counts, CountryName
  FROM Countries GROUP BY CountryName
HAVING COUNT(Id) < 5

Result:-

Counts CountryName
--------------------
1 Australia
1 India
1 Nepal
1 Rasia
1 USA

Other Example,

SELECT COUNT(Id) AS [Count], CountryName FROM Countries
      WHERE CountryName <> 'INDIA'
   GROUP BY CountryName
  HAVING COUNT(Id) <= 5
ORDER BY COUNT(Id) DESC

Result:-

Count CountryName
-------------------
1 Australia
1 Nepal
1 Rasia
1 USA

Stayed Informed - SQL Server Query and Examples

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2