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. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Introduction of MS SQL Server
- Where clause in MS SQL Server
- Difference between MS SQL Server and IBM DB2
- Difference between MS SQL Server and IBM Db2
- SQL Server Identity
- Mean and Mode in SQL Server
- SQL Server | SERVERPROPERTY()
- SQL SERVER | IN Condition
- Primary key in MS SQL Server
- Having clause in MS SQL Server
- Select top in MS SQL Server
- Foreign key in MS SQL Server
- Difference between MS SQL Server and MongoDB
- Difference between MariaDB and MS SQL Server
- Difference between Redis and MS SQL Server
- Select statement in MS SQL Server
- Difference between Derby and MS SQL Server
- Insert statement in MS SQL Server
- Allow only alphabets in column in SQL Server
- Difference between SQLite and MS SQL Server
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.