mysql 先求和后再算和的最大值

mysql 先求和后再算和的最大值

问题描述的不清楚。b,c是不是同一字段。你这里少个order 吧。order by a、
你要实现什么业务逻辑追问将b求和，然后求出这些分组里最大的sum(b)追答select sum(b) from t group by a order by sum(b) desc

SELECt a,MAX(b)V,sum(c) FROM t group by a
你是这个意思吧追问不是，将b求和，然后求出这些分组里最大的sum(b)追答db2 可以这样
select
t1.a
,max(v1) over() v1
,v2
from (SELECt a,sum(b)V1,sum(c) v2 FROM tablename1 group by a) t1

笨办法
select
t1.a
,t3v1
,t1.v2
from (SELECt a,sum(b)V1,sum(c) v2 FROM tablename1 group by a) t1
(select max(v1) v1 from (SELECt a,sum(b)V1,sum(c) v2 FROM tablename1 group by a) t2) t3
where 1=1

你这个里面包含了两成意思，
1.根据a字段 group
select a,sum(b) ,sum(c) from t
group by a
2.获得的结果再求最大值与其对应的A字段值
对不？如果上述分析正确，可以这么做
先求出最大和后赋给对应变量 max_s_b
select max( s_b) from
(select a,sum(b) s_b ,sum(c) s_c from t
group by a)tg1
再求出对应的最大值的记录
select a,sum(b) s_b ,sum(c) s_c from t
group by a
having sum(b) = max_s_b