Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need a group by clause?
- 4 Answers
- 10182 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / ricky
while we are using a aggregate function we use the group by
clause....
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the temp table?
What is a filestream?
Define constraints and give an example of their use?
Do you know what is fill factor and pad index?
What is indexed view?
How you can find out if an index is useful to the optimizer?
Should you normalize audio?
What is 'Join' and explain its various types.
How can you set the threshold at which sql server will generate keysets asynchronously?
What are functions in the sql server?
what purpose does OPENXML clause have in sql server stored procedure?
How do you create type- insensitive operator?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
