SQL Server ORDER BY clause

As stated here ,

ORDER BY clause -

• Order the result set of a query by the specified column list and, optionally, limit the rows returned to a specified range. The order in which rows are returned in a result set are not guaranteed unless an ORDER BY clause is specified.

SQL Server ORDER BY using Alias name of the column mentioned in the SELECT statement 

SQL Server - ORDER BY with CASE statement - Example

T-SQL - Using Order By clause to return resultset with exact matches first and then partial matches

SQL Server 2012 - OFFSET and FETCH (Enhancement in ORDER BY clause) 

Reference link :

• http://technet.microsoft.com/en-us/library/ms188385.aspx

See Also:

• My posts on T-SQL scripts