很简单,直接在order by后面进行加就可以了:
升序:
select *
from stor
order by (A+B+C+D)
降序:
select *
from stor
order by (A+B+C+D) desc
select a+b+c+d as abcd from stor order by abcd ;
select *,(A+B+C+D) as sum from stor order by sum
select * from stor order by A+B+C+D
select (a+b+c+d) as total from stor order by total desc