Group By In SQL Server we have got many aggregate functions. Examples
1. Count()
2. Sum()
3. avg()
4. Min()
5. Max()The GROUP BY statement groups rows that have the same values into summary rows,. It is often used in conjunction with one or more aggregate functions.
I want an MS SQL query, which gives total salaries paid by City. show below
Query for display total salaries by city:
We are getting apply SUM() aggregate function on Salary column, and grouping by city column.
Select City, SUM(Salary) as TotalSalary
from tblEmployee
Group by City
Note: If you leave, the group by clause and try to execute the query, then you get an error - Column 'tblEmployee. City' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
