Order Columns « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. Order Columns
1.Order criterion may contain more than one column
2.Identify the columns in the ORDER BY clause by the ordinal position of the column in the SELECT list
3.Order by two columns
4.Using a CASE Expression in an ORDER BY Clause
5.Using a CASE Expression in an ORDER BY Clause (Alternative)