Demonstration of the ORDER BY clause should include the following sorting or querying strategies performed on a given set of data:
- Ascending—will cause the result set to be ordered from smallest to largest
- Descending—is typically the default order, 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 ResultSet after all selection criteria is executed.