15 Best SQL Queries for Developers [SQL Queries]

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.


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!!
ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book