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.
SELECT column1, column2, …
ORDER BY column1, column2, … ASC|DESC;
SELECT * FROM `employees` order by hire_date DESC
As you can see we have fetched the records based on the descending order of hire date
SELECT * FROM `employees` order by hire_date ASC
As 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