SQL Group by Clause
Hi friends, in this post we will learn about SQL Group by Clause. Group By clause is used to group the result.
Earlier we had discussed about SQL Order By Clause,SQL Select Top Clause, Like Clause SQL Server, SQL AND & OR Operators, SQL Where Clause, Delete Query SQL Server, SQL Update Statement, SQL Select Statement, SQL Insert Statement, Drop Table SQL Server, Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.
Table Structure 1:
ID | NAME | AGE | ADDRESS | SALARY |
1 | MANN | 30 | GURGAON | 20000 |
2 | JAI | 21 | Delhi | 15000 |
3 | AMAN | 33 | Kota | 12000 |
4 | AMIT | 25 | Mumbai | 6000 |
5 | SURESH | 37 | Bhopal | 8000 |
6 | Komal | 22 | GURGAON | 4000 |
in above table we have all names are unique, so group by does not work.
SQL Group by Query Example 1:
----SELECT DATABASE---- USE HIGHTECHNOLOGY GO ----GROUP BY EXAMPLES---- ----GROUP BY WITH DISTINCT NAME---- SELECT NAME, SUM(SALARY) FROM EMPLOYEE GROUP BY NAME GO
Table Structure 2:
ID | NAME | AGE | ADDRESS | SALARY |
1 | MANN | 30 | GURGAON | 20000 |
2 | JAI | 21 | Delhi | 15000 |
3 | AMAN | 33 | Kota | 12000 |
4 | AMIT | 25 | Mumbai | 6000 |
5 | SURESH | 37 | Bhopal | 8000 |
6 | Komal | 22 | GURGAON | 4000 |
7 | MANN | 31 | DELHI | 22000 |
In above table we have one duplicate name ‘MANN‘, so group by works and group the result set by name. Hence it groups result of name MANN.
SQL Group by Query Example 2:
----SELECT DATABASE---- USE HIGHTECHNOLOGY GO ----GROUP BY EXAMPLES---- ----GROUP BY WITH ONE NAME DUPLICATE---- SELECT NAME, SUM(SALARY) FROM EMPLOYEE GROUP BY NAME GO