a b
100 1
150 1
200 1
125 2
85 2
-------------
结果
200+125=325
如何写语句.
------解决方案--------------------
select sum(a) from (select max(a) as a from table group by b) aa
------解决方案--------------------
select sum(a) from [Table] a where not exists(select 1 from [table] where b=a.b and a> a.a)
------解决方案--------------------
select sum(a) from (SELECT max(a) a,b FROM TABLE GROUP BY b) tbale2
------解决方案--------------------
a b
100 1
150 1
200 1
125 2
85 2
-------------
结果
200+125=325
---------------------------
select sum(a)as a from
(
select max(a)as a ,b from t group by b
)b