mysql - 如何找到两个数字之间的绝对差MYSQL

Question

在 MYSQL 中找到两个数字之间的绝对差以便我可以排序结果的最佳方法是什么？仅当 numberA 大于 numberB 时，下面的代码才有效，但如您所见，情况并非总是如此。有没有一种用一条语句就可以做到这一点的好方法？

SELECT (numberA - numberB) AS spread 
FROM table 
ORDER BY spread DESC

|-------------------|
| numberA | numberB |
| 5.4     | 2.2     |
| 7.7     | 4.3     |
| 1       | 6.5     |
| 2.3     | 10.8    |
| 4.5     | 4.5     |

Answer 1

就像 that 一样简单:

SELECT ABS(numberA - numberB) AS spread 
FROM table 
ORDER BY spread DESC

或者，如果你想 select the pair (numberA, numberB) in descending order of their difference :

SELECT numberA, numberB
FROM table 
ORDER BY ABS(numberA - numberB) DESC