大家请进！谢谢！

[pzrr_00]

现有一问题，实在是捆扰了我好久了～
表table:(a,b,c)
比如select max(a) from table group by c
但是在这里我想相应获得对应这些按Ｃ分组后最大的a对应的b,该如何写？请指教！谢谢！

[spring_504]

select b from table where a+c in (select max(a)+c from table group by c)

[mschen]

select b

from 表 t

where a=(select max(a) from 表 where c=t.c)

[mschen]

select b
from 表 a
join
(
select c
,max(a) as max_a
from 表
group by c
) t on a.c=t.c and a.a=max_a

[wgsasd311]

假如表为test1:
select b from test1 where a in(select max(a) from test1 group by c)