Order by in MS SQL Server
In this article, order by and terms related to order by will be discussed.
- There are some instances where the tables are to be arranged in a chronological order.
- While the users use the select statement to retrieve rows, one cannot guarantee that the rows are arranged in an order.
- To solve this, order by clause is being used.
select select_list from table_name order by
Example: Sample table-Student
If a user wants to arrange the names in an order then the query must be written as follows:
select roll number name course from student order by name
The output is:
Note that the table is arranged in ascending order by default using the order by clause.
ASC | DESC :
- A user can arrange the columns in ascending or descending order using ASC or DESC respectively.
- ASC arranges the columns from lowest to highest
- DESC arranges the columns from highest to lowest.
- If there is a NULL column in the table, it will be treated as the lowest value.
Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course by GeeksforGeeks.