Sql-order by multi field sorting (ascending and descending)

Time:2021-10-17
ORDER BY _ column1, _ column2; /* _ Column1 in ascending order_ Column2 ascending*/ 

ORDER BY _ column1, _ column2 DESC; /* _ Column1 in ascending order_ Column2 descending*/ 

ORDER BY _ column1 DESC, _ column2 ; /* _ Column1 in descending order_ Column2 ascending*/ 

ORDER BY _ column1 DESC, _ column2 DESC; /* _ Column1 in descending order_ Column2 descending*/