Goup by clause

Question

Example on table data

Jignesh Trivedi · Answer

Hi, what exact you looking for Group by clause? Please refer below link it might help you. http://technet.microsoft.com/en-us/library/ms177673.aspx

Munesh Sharma · Answer

go on this link http://www.w3schools.com/sql/sql_groupby.asp

Rajneesh Rai · Answer

Hello Vevek, Group By : Groups a selected set of rows into a set of summary rows by the values of one or more columns or expression. For example: consider the following simple example, CREATE TABLE EMPLOYEE ( ID INT IDENTITY(1,1), NAME VARCHAR(50), DEPARTMENT VARCHAR(50) ) GO INSERT INTO EMPLOYEE SELECT 'RAJNEESH RAI', 'IT' UNION ALL SELECT 'VIVEK','IT' UNION ALL SELECT 'SEEMA','HR' UNION ALL SELECT 'MELISSA','ADMIN' GO -- Now i want to get the number of employees in each department, for that i have to group all the employees by their department. SELECT DEPARTMENT,COUNT(NAME) FROM EMPLOYEE GROUP BY DEPARTMENT Hope you got it :) For more details go through following links : 1. http://www.w3schools.com/sql/sql_groupby.asp 2 . http://technet.microsoft.com/en-us/library/ms177673.aspx

Abhay Shanker · Answer

The Group By Clause is used with collabration With Select Statement to arrang identical data in group. It follows where clause in select statement and preceds the order by Select department, sum(sales) from order group by (department)

Goup by clause

Answers (4)