查询问题

[daijingjie2002]

如下表
a b c
w 0.1 1
w 0.3 2
w 0.2 3
w 0.6 4
A列为编码，B列为单价，C列为月分，如何查询出最大的一个月的单价

[ygghost]

select b from table where c=max(c)

select top 1 b from table order by c desc

[zjcxc]

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

[pbsql]

select t.a,t.b,t.c
from t,(select a,max(b) from t group by a) tem
where t.a=tem.a and t.b=tem.b

[iintsy]

SELECT a,b,c FROM 表名 where b = (SELECT MAX(b) from 表名)

[midnight2002]

select a,max(b),c from table_name group by a,c

[midnight2002]

刚才的有点问题，不好意思！！！

测试数据如下：
create table test(a char(1),b float,c int)

insert into test select 'w',0.1,1
union select 'w',0.3,2
union select 'w',0.2,3
union select 'w',0.6,4

select a,max(b),max(c) from test group by a

a
---- ----------------------------------------------------- -----------
w 0.59999999999999998 4

（所影响的行数为 1 行）

[long0104]

select * from 表 where b=max(b)