Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need a group by clause?
- 4 Answers
- 10493 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 |
Explain some DBCC commands?
select top 5 * from emp order by newid() my question is , how this query get executed?
Why use sub query in sql server and list out types of sub queries?
What is difference between table aliases and column aliases? Do they affect performance?
What is the sql server 2000 version number?
What is equi join with example?
What is a db view?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What are the authentication modes in sql server? How can it be changed?
what is spatial nonclustered index
what are the problems in logshipping?
WHAT OPERATOR PERFORMS PATTERN MATCHING?
2 Answers CarrizalSoft Technologies, CTS,
-
Oracle (3253) - 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)
