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
List the ways in which dynamic sql can be executed?
What is the difference between for xml raw and for xml auto?
Where can you add custom error messages to sql server?
How efficient you are in oracle and SQL server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can we do dml on views?
How to provide default values to function parameters?
How to convert character strings into numeric values?
Why use identity in sql server?
List out the different types of locks available in sql server?
What is sql server query analyzer?
What are different types of constraints?
What are the source of constraints?
How can I check that whether automatic statistic update is enabled or not?
How to convert numeric expression data types using the cast() function?
