GeekInterview.com
Series: Subject: Topic:
Question: 187 of 195

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

Asked by: Interview Candidate | Asked on: Aug 28th, 2004
Showing Answers 1 - 4 of 4 Answers
Mohan kumar.k

Answered On : 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.

  
Login to rate this answer.
sivanagalakshmi

Answered On : Oct 3rd, 2006

GROUP BY:IT IS USED TO FILTER THE DATA BASED ON DIFFERENT DEPARTMENTS

  
Login to rate this answer.
sateesh

Answered On : 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

  
Login to rate this answer.
jyoti_jys

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.