python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions