Title: Sort data using the ORDER BY clause.
Course: Database Design and Management (Oracle) (10052) > Section: Restricting and Sorting Data Using SQL

Demonstration of the ORDER BY clause should include the following sorting or querying strategies performed on a given set of data:

- Ascending—sorts from smallest to largest
- Descending—sorts from largest to smallest
- Multiple columns—will produce sorting among results of a particular type
- Column alias—is an alternate name assigned to a column to prevent query conflicts

Note: ORDER BY is always the last clause because it rearranges the final output after all selection criteria is executed.