The data is not displayed in any particular order when you simply fetch it from MySQL table. For displaying data in some meaningful way ORDER BY clause is used.
This sorts your result on the basis of column name specified in the clause within the SELECT query.
It allows us to –
- Specify ordering in single or multiple columns
- Define sort results in ASC or DESC format.