Order by multiple conditions

The Order clause sorts the query results by one or more (up to 16) fields, either ascending or descending. The default value is ascending. The Order clause is usually placed at the end of an SQL statement. Multiple fields are defined in the order clause.

Example:

SelectProductname, unitprice, unitinstockFromProductsOrderByUnitinstockDesc, UnitpriceDesc, Productname

If order by is not a number but a varchar type, cast conversion is required. You can also use multiple conditions, as shown below:

Order By Cast(M. process_card_codeAs Int),Cast(N. procedure_noAs Int)