Re: order by max of two columns

[Ramalingam Chelliah]

Hi,
If you like to order records in table by Max( column1,Column2)

Try this ..

mysql> SELECT * from
tablename
ORDER BY ABS(Column1-Column2);

Hope this helps...

Regards,
Ram.

PS: My Trial

mysql> select * from Max2C;
+----+------+------+
| ID | No1 | No2 |
+----+------+------+
| 1 | 12 | 15 |
| 2 | 15 | 11 |
| 3 | 10 | 12 |
| 4 | 1 | 20 |
+----+------+------+
4 rows in set (0.00 sec)


mysql> select No1,No2 from Max2C
-> ORDER BY ABS(No1-No2);
+------+------+
| No1 | No2 |
+------+------+
| 10 | 12 |
| 12 | 15 |
| 15 | 11 |
| 1 | 20 |
+------+------+
4 rows in set (0.00 sec)





We Learn the Most When we have to Invent