Answer Posted / Shambhu Kumar
By default, GROUP BY does not sort data. If you want your data sorted after being grouped, you should use the ORDER BY clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
How to enter binary string literals in ms sql server?
How do I create a trace in sql server?
Disadvantages of the indexes?
Can you index views?
How to connect php with different port numbers?
Equi join and non equi join is possible with sql server?
How do I find query history in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is normalization and what are the advantages of it?
What are the kinds of subquery?
do you know how to configure db2 side of the application? : Sql server database administration
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is acid mean in sql server?
What are wait types?
