How to sort the query output with order by clauses in ms sql server?
- 1 Answers
- 1107 Views
- I also Faced
- E-Mail Answers
Answer Posted / Satendra Kumar Bharti
You can sort the query output using the ORDER BY clause in MS SQL Server. Here's an example:n```sqlnSELECT column1, column2 FROM table_name ORDER BY column1 ASC;```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How can we solve concurrency problems?
What are the different types of subquery?
What are the different SQL Server Versions you have worked on?
What is a coalesce function?
What is the primary use of the model database?
What kind of problems occurs if we do not implement proper locking strategy?
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 in place upgrade in sql server?
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?
How to convert character strings into numeric values?
List the ways in which dynamic sql can be executed?
What is normalization and what are the advantages of it?
What are wait types?
Can you index views?
