See The Syntax For ORDER BY clause?

ORDER BY { column-Name | ColumnPosition }
    [ ASC | DESC ]
    [ , column-Name | ColumnPosition
        [ ASC | DESC ] ] *