While using Order by for more than 1 column which column will get priority while sorting?

Question

In case of order by last name, age means if the records are last name anderson age 55 and last name Bharat and age 16. How will they get sorted

Answer 1

whichever you mention 1st
order by last_name, age
Anderson, 55
Bharat, 16

order by age, last_name
Bharat, 16
Anderson, 55

or you could use desc on either to reverse the ordering