...order by (case when column1>column2 then column1 else column2 end)

嘎嘎，我喜欢用大于号