Goup by clause

vivek upadhyay

12y1.7k

Example on table data

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
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
0
Munesh Sharma12y ago
go on this linkhttp://www.w3schools.com/sql/sql_groupby.asp
0
Rajneesh Rai12y ago
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
0
Abhay Shanker12y ago
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)
0