MySQL Order By:
When you use the SELECT statement to query data from a table, the result set is not sorted in any order. To sort the result set, you use the ORDER BY clause. The ORDER BY clause allows you to-
- Sort a result set by a single column or multiple columns.
- Sort a result set by different columns in ascending or descending order.
Syntax of MySQL Order By Clause:
|SELECT * FROM table_name ORDER BY |
col1 ASC | DESC
Example of MySQL Order By Clause for Ascending Order (ASC):
Example of MySQL Order By Clause for Descending Order (DESC):
When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.
Syntax of MySQL Distinct:
|SELECT DISTINCT column_name FROM table-name|