In the ‘select’ statement what is “group by”?

Showing Answers 1 - 4 of 4 Answers

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.

  Was this answer useful?  Yes

sivanagalakshmi

  • Oct 3rd, 2006
 

GROUP BY:

IT IS USED TO FILTER THE DATA BASED ON DIFFERENT DEPARTMENTS

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions