select id,sum(字段1)+sum(字段2) as ab FROM `表名` GROUP BY id order by ab desc ;
同一个表的俩个字段相加排序
最新推荐文章于 2021-01-19 04:27:36 发布
select id,sum(字段1)+sum(字段2) as ab FROM `表名` GROUP BY id order by ab desc ;