ORDER BY

 Sorting by Column Position

 

 ORDER BY also supports ordering specified by relative column position.

SELECT prod_id, prod_price, prod_name

FROM Products

ORDER BY 2, 3;

If you want to sort descending on multiple columns, be sure each column has its own DESC keyword.

SELECT prod_id, prod_price, prod_name

FROM Products

ORDER BY prod_price DESC;