EmersonH.Com

Transforming Knowledge into Power

  • Increase font size
  • Default font size
  • Decrease font size
Home T-Sql SQL ORDER BY

SQL ORDER BY

E-mail Print

The ORDER BY Keyword


The ORDER BY keyword is used to sort the result-set by a specified column.


The ORDER BY keyword sort the records in ascending order by default.


If you want to sort the records in a descending order, you can use the DESC keyword.


SQL ORDER BY Syntax
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC