sql multiple order by with case code example

Example: multiple order by sql

ORDER BY column1 DESC, column2