How To Use GROUP BY Keyword In SQL

In this article, we will learn how to use the GROUP BY keyword in SQL.

The GROUP BY statement is used to group rows that have the same values.

The GROUP BY statement is usually used with Aggregate Functions to group the result-set by one or more columns.

Syntax

SELECT column_name(s)
FROM TABLE_NAME
GROUP BY column_name(s);

Example

The subsequent statement would list the number of viewers in each city:

SELECT COUNT(ID), City
FROM Viewers
GROUP BY City;

Note: In the query, the GROUP BY clause is placed after the WHERE clause and before the ORDER BY clause if used any.

Also, check How To Use UNION Operator In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.

Next How To Use HAVING Clause In SQL »

Previous « How To Use UNION Operator In SQL

View Comments

Hairstyles says:

December 10, 2019 at 3:25 pm

Just want to say your article is as astonishing. The clarity in your post is just excellent and i can assume you are an expert on this subject. Well with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the gratifying work.
- Yasin Panwala says:
  
  December 11, 2019 at 10:32 am
  
  Thanks for your precious comment.