sql server order by multiple fields code example

Example: sql order by two columns

ORDER BY column1 DESC, column2