ORDER BY Clause

Ordering according to multiple columns:

We can also order from the table according to multiple columns also by using the (,) operator in the syntax as follows:

Syntax:

Here

SELECT col1,...coln FROM `table_name` is the command that tells the MySQL server to select the col1,..coln from `table_name.`

(column_1,column_2,…) specifies the columns to select from.

Example

Consider the same student’s records table. What will be the command if we wish to display the table by descending order of marks and by ascending order of roll no. as well?

The above query will result in:

FAQs

1. What is the syntax if we want to retrieve data in a specific order from the table?

Here

SELECT col1,...coln FROM `table_name` is the command that tells the MySQL server to select the col1,..coln from `table_name.`

(column_1,column_2,…) specifies the columns to select from.

Here ASC is for ascending order display, and DESC is for descending order display.

2. What is the purpose of the ORDER BY clause?

For getting the sorted records in the table, we use the ORDER BY command. The ORDER BY keyword sorts the records in ascending order by default.

3. Can we use the where clause after ORDER BY?

Yes, we can use the WHERE clause with or without the ORDER BY statement. We can filter records by finite values, comparison values, or with sub-SELECT statements. The WHERE clause gives you several options when filtering data.

4. What is the difference between GROUP BY and ORDER BY?

Group by clause is used to group the rows that have the same value, whereas Order by clause sort the result-set either in ascending or in descending order.

Key Takeaways

In this blog, we learned about the ORDER BY clause in SQL queries. 

We begin with learning the syntax of these statements and how to use them in queries with various examples. 

Visit here to learn more about different topics related to database management systems. Also, try Coding Ninjas Studio to practice programming problems for your complete interview preparation. Don't stop here, Ninja; check out the Top 100 SQL Problems to get hands-on experience with frequently asked interview questions and land your dream job.