ORDER BY Clause MYSQL

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.


Syntax:

SELECT column1, column2, …
FROM table_name
ORDER BY column1, column2, … ASC|DESC;

Query 1:

SELECT * FROM `employees` order by hire_date DESC


Output
:

Order By Clause ExampleAs you can see we have fetched the records based on the descending order of hire date

 

Query 2:

SELECT * FROM `employees` order by hire_date ASC


Output
:

Order By Clause ExampleAs you can see we have fetched the records based on the ascending order of hire date

Tester Usage Tips:

  • Validate sorted records by date for example in UI data table/grid  
  • Validate the time stamp sequencing of the records for example customers invoices by date and time