Omnidex SQL: SELECT ORDER BY Clause

The ORDER BY clause is used to return selected rows in ascending or descending order.

  ORDER BY [  column_spec | column_position ] [ ASC | DESC ] 
           [, column_spec | column_position ] [ ASC | DESC ]

select trans_date, trans_amount from trans_table order by trans_date;

select trans_date, trans_amount from trans_table order by 2;

The column_spec can be in the format of [database.][table.]column or table_alias.column.

select trans_date, trans_amount from trans_table order by db1.trans_table.trans_amount;

Column_spec can also be prefixed with an alias name of the table's column or an alias name of an expression.

select trans_date, trans_amount - discount NetAmount from trans_table order by NetAmount;

The ASC/DESC modifier can be used to return the data in ascending or descending order with ascending order being the default.

select trans_date, trans_amount from trans_table order by trans_date desc;