Order « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. Order
1.Use the ORDER BY clause
2.Order by date
3.Order the result set by ascending order
4.Order in descending order
5.Using Order By clause to order result
6.Order string/char value descending
7.Put the sort direction against each item in the ORDER BY clause
8.Put the DESC in the first item in order by clause
9.In an ascending order




10.Distinct order
11.ORDER BY is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is specified