It is used with 2 options:
- ASC - ascending order (it is default, you can ignore writing it)
- DESC - descending order
Example: Select employees from employee table and sort employee names in alphabetical order.
SELECT * FROM tableEmployee ORDER BY employeeName ASC
Select employees sort them by employee names in ascending order, but by birthday in descending order.
SELECT * FROM tableEmployee ORDER BY employeeName ASC, employeeBirthday DESC
No comments:
Post a Comment