Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain the truncate command? : SQL Server Architecture
What are the restraints imposed on the table design by a merge replication?
Can a table be moved to different filegroup?
What are two difference between sql azure and azure tables?
What is the difference between system objects and user objects?
What is difference between aggregate and analytic function?
How to get the number of affected rows?
How to start sql server browser service?
What is an indexing technique?
Suggest a method of joining two tables.
What is the difference between deallocate cursor and close cursor?
what is a check constraint?
What is self contained sub query?
Explain trigger and its types?
What is t-sql script to take database offline – take database online.
