I have table like this ordered in DESC order by value “key”:
x
name | key
Bman 9.5
Cman 9.5
Aman 9.5
Ara 9.3
I want to sort it alphabetically when the key value is same So I want it to be like this:
name | key
Aman 9.5
Bman 9.5
Cman 9.5
Ara 9.3
How can I do that?
Advertisement
Answer
Just use two order by
keys:
order by key desc, name