How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.