MYSQL ORDER BY ASC DESC

ORDER BY keyword is used to sort records in the form of ascending or descending.

For the ORDER BY command, we will use this given table as an example.

ORDER BY (ASC)

This command will fetch all the records from a table by sorting specified field values in ascending order.

SELECT * FROM users ORDER BY country ASC;

ORDER BY (DESC)

This command will fetch all the records from a table by sorting specified field values in descending order.

SELECT * FROM users ORDER BY country DESC;