The GROUP BY Clause in SQL is used to club similar forms of data into groups. I.e. if a Column A has same values in different rows then it will arrange these rows in a group.
GROUP BY returns only one result per group of data and is used with the SELECT statement
GROUP BY aggregates the results on the basis of selected column: COUNT, MAX, MIN, SUM, AVG, etc.
Group BY : keyword used to group identical records in a table.
Table_name : The name of the table from where you want to fetch the data
Column1Name, Column2Name : The name of the columns of the table which you want to uniquely fetch.
Let’s query PersonalInfo Table in our Demo Database and check the count of PersonId using Group by
Figure 20.1. Select * from PersonalInfo;
Figure 20.2 Group by on PersonalInfo;
Want More SQL Deep Dives