Answer Posted / Sudhir Kumar Trivedi
In SQL Server, 'order by' sorts the result set in ascending or descending order. 'Group by', on the other hand, groups rows that have the same values in specified columns and performs aggregation operations (such as sum, count, etc.) on each group.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
Why use identity in sql server?
What is a coalesce function?
What is clustered index
Disadvantages of the indexes?
How do I create a trace in sql server?
What are the different SQL Server Versions you have worked on?
Is it possible to have clustered index on separate drive from original table location?
Can one drop a column from a table?
How can I check that whether automatic statistic update is enabled or not?
What is sql server query analyzer?
What are the different subsets of sql?
What is the difference between upgrade and migration in sql server?
do you know how to configure db2 side of the application? : Sql server database administration
When should you use an instead of trigger?