ORDER BY clause syntax:
SELECT column1, SUM(column2) FROM "list-of-tables" ORDER BY
"column-list" [ASC | DESC];
[ ] = optional
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.
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;
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.
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
1) Select the lastname, firstname, and city for all customers in
the customers table. Display the results in Ascending Order based on
the lastname.
2) Same thing as exercise #1, but display the results in
Descending order.
3) 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:
|