Mohan kumar.k

• Sep 27th, 2005

 

 Group by clause  is used to  fetch  the data from the table by the specified field

 ex.select count (*)  from emptable group by deptno where deptno = 1.

 It is used to find the number of employees present in the specified department no.

sivanagalakshmi

• Oct 3rd, 2006

 

GROUP BY:

IT IS USED TO FILTER THE DATA BASED ON DIFFERENT DEPARTMENTS

sateesh

• Dec 15th, 2006

 

group by uses in the select statement when ever we want to access data based on the specific filed and when ever we use aggrigate functions

jyoti_jys

• Nov 6th, 2007

 

The use of GROUP BY has the prerequisite that SELLECT only individual columns, not all the columns, are specified using *. If GROUP BY is used, all columns that are specified directly after SELECT and not specified as an argument of an aggregate function must be listed there.