Example: Ordering on Column Name or Column Position Using an Ascending or Descending Sort Sequence - Analytics Database - Teradata Vantage

Each of the following statements can be used to list employees by department number, with the highest paid employee listed first and the lowest paid last:

     SELECT name, dept_no, salary
     FROM employee
     ORDER BY 2 ASC, 3 DESC;
     SELECT name, dept_no, salary
     FROM employee
     ORDER BY dept_no, salary DESC;