如何按MySQL中两列的最大值排序？

mysql> insert into DemoTable834 values(10,20);
mysql> insert into DemoTable834 values(40,50);
mysql> insert into DemoTable834 values(20,24);
mysql> insert into DemoTable834 values(30,10);


以下是使用以下命令按两列中的最大值排序的查询GREATEST()：

mysql> select *from DemoTable834
order by greatest(Value1,Value2) DESC;