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 to count rows with the count(*) function in ms sql server?

0 Answers  

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

How to include text values in sql statements?

0 Answers  

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

Define magic tables in sql server?

0 Answers  

Explain the concepts and capabilities of sql server?

0 Answers  

What are key constraints?

0 Answers  

Explain various data region available in ssrs with their use?

0 Answers  

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

What is a db view?

0 Answers  

List the various tools available for performance tuning?

0 Answers  

How to list all schemas in a database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories