The default ORDER BY

Ordering with NULL

The ordering of the data

Ordering by Alias

Order By Limitations and Restrictions

Implementing a custom sort

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.

Returning Sorted Record Sets Using the ORDER BY Clause

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.

Order By Clause