MySQL: Order by with Multiple columns

Profile picture for user arilio666

ORDER BY clause in MySQL is another key feature when it comes to ordering the table content in descending or in ascending order where you wanna know pieces of information about the table in a certain order.

  • We can also do ORDER BY with multiple columns asking it to display in ascending or descending based on our wish.
  • So this clause will help do that with ease.
  • We will generally use this clause to get an order of certain columns to our liking.

Syntax

SELECT * from TableName ORDER BY ColumnName1, ColumnName2;

By default, it will display in the order of ascending order whereas when we want in descending order we will be using the DESC clause to query the table in descending order.

For demo purposes, we will be using the products table to query out the name in ascending and quantity columns.

This is the example we will be doing today, so let us dive into the scenario.

Example

select * from products order by name asc, quantity_in_stock ;

  • So here we can see that the name column has been arranged in ascending order as per our wish along with the quantity_in_stock column to represent the matching name column in ascending to it.
  • So in this way, we can do the order with multiple columns.
Tags