Explain GROUPBY function in SQL Server.

The GROUPBY function is used to group the results fetched from one or more columns. It is widely used with aggregate functions.

Ex :

Select EmployeeName, sum(EmployeeSalary) from Employees

Group by EmployeeName

This Query will display the total sum(Employee Salary) of each employee and group by the employees name.