ORDER BY expression-list

Expressions can be used in the ORDER BY clause. For example, in the following clauses the table is ordered by three key expressions: a+b, c+d, and e.

SELECT * FROM emp  
ORDER BY a+b,c+d,e  

No ordering is allowed on set functions or an expression that contains a set function.