21,886
社区成员
发帖
与我相关
我的任务
分享
select sum(if(gid=1,gprice*10,0))+sum(if(gid=2,gprice*5,0)) as total from price group by gid;
SELECT
(SELECT SUM(gprice*10) as gprice FROM dbtable Where gid=1)
+
(SELECT SUM(gprice*2) as gprice FROM dbtable Where gid=2)
[+ .....];
SELECT SUM(gprice*10) as gprice FROM dbtable Where gid in( 1, 2 );