Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Why we need a group by clause?

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback



Why we need a group by clause?..

Answer / sd

While using aggregate functions.

Is This Answer Correct ?    7 Yes 1 No

Why we need a group by clause?..

Answer / vampire007

We use GroupBy clause to analyze data in table,by means of
various sql server aggregate functions like SUM(), AVERAGE
() etc., according to some domain.

For eg., If we want to know the sales done by a every
employee, then we would use somewhat this kind of query:

/**
select employeeid, count(*)
from orders
groupby employeeid
order by employeeid
**/

Is This Answer Correct ?    7 Yes 1 No

Why we need a group by clause?..

Answer / satyanarayana

In order to provide a condition to the select statement
either by group by column or aggregate function

Is This Answer Correct ?    1 Yes 0 No

Why we need a group by clause?..

Answer / ricky

while we are using a aggregate function we use the group by
clause....

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How do you run a trace?

0 Answers  

What does null mean?

0 Answers  

How to test odbc dsn connection settings?

0 Answers  

What is ms sql server triggers?

0 Answers  

What is Outter Join?

1 Answers  

What happens to a statement batch if there is a compilation error?

0 Answers  

What is the cartesian product of the table?

0 Answers  

what is IDE,DMV in sql server?

1 Answers   Value Labs,

What are the four main query statements?

7 Answers   Wipro,

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

Describe triggers features and limitations?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories