ORDER BY clause
ORDER BY is an optional clause which will allow you to display the results of your query in a sorted order (either ascending order or descending order) based on the columns that you specify to order by.
ORDER BY clause syntax:
SELECT column1, SUM(column2) FROM "list-of-tables" ORDER BY "column-list" [ASC | DESC];
[ ] = optional
This statement will select the employee_id, dept, name, age, and salary from the employee_info table where the dept equals 'Sales' and will list the results in Ascending (default) order based on their Salary.
ASC = Ascending Order - default
DESC = Descending Order
For example:
SELECT employee_id, dept, name, age, salary FROM employee_info WHERE dept = 'Sales' ORDER BY salary;
If you would like to order based on multiple columns, you must seperate the columns with commas. For example:
SELECT employee_id, dept, name, age, salary
FROM employee_info
WHERE dept = 'Sales'
ORDER BY salary, age DESC;
Review Exercises
- Select the lastname, firstname, and city for all customers in the customers table. Display the results in Ascending Order based on the lastname.
- Same thing as exercise #1, but display the results in Descending order.
- Select the item and price for all of the items in the items_ordered table that the price is greater than 10.00. Display the results in Ascending order based on the price.
Click the ORDER BY Exercise Answers link below if you have any problems.
Answers to these Exercises
Enter SQL Statement here: