同一个表的俩个字段相加排序

select id,sum(字段1)+sum(字段2) as ab FROM `表名` GROUP BY id order by ab desc ;