求一语句,取最大的求和
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