今天有人问我mysql如何跨字段求和 并排序,故做此笔记,以备查看,至于多字段其余数字运算类型可借此举一反三,故不详述……
多字段求和分组排序
select pid,sum(a)+sum(b) as ab FROM `table_name` group by pid order by ab desc
多字段求和排序
select pid,sum(a)+sum(b) as ab FROM `table_name` order by ab desc
今天有人问我mysql如何跨字段求和 并排序,故做此笔记,以备查看,至于多字段其余数字运算类型可借此举一反三,故不详述……
多字段求和分组排序
select pid,sum(a)+sum(b) as ab FROM `table_name` group by pid order by ab desc
多字段求和排序
select pid,sum(a)+sum(b) as ab FROM `table_name` order by ab desc