SQL 多个字段值相加后排序问题

Question

现有一个表stor中有 A B C D这四个字段，字段中都是存的数字数据。
现在我要把ABCD这个值相加后进行升降序排序用什么SQL语句。不能用先把每行数据取出来，把ABCD相加后再存到一个数组里，然后再在数组里进行升降排序这种方法。

Answer 1

很简单,直接在order by后面进行加就可以了:

升序:
select *
from stor
order by (A+B+C+D)

降序:
select *
from stor
order by (A+B+C+D) desc本回答被提问者采纳

Answer 2

select a+b+c+d as abcd from stor order by abcd ;

Answer 3

select *,(A+B+C+D) as sum from stor order by sum

Answer 4

select * from stor order by A+B+C+D

Answer 5

select (a+b+c+d) as total from stor order by total desc