SQL order by highest value of two columns

sql postgresql

SELECT  *FROM    mytableORDER BY        GREATEST(pc_1, pc_2) DESC, LEAST(pc_1, pc_2) DESC

sql postgresql

select *from mytableorder by case when pc_1 > pc_2 then pc_1 else pc_2 end desc,case when pc_1 > pc_2 then pc_2 else pc_1 end desc

CodeHunter