求助一个SQL语句怎么写

[qczl1224]

a b c
1 ww 100
2 ww 110
3 mm 90
4 mm 95
5 mm 120
6 yy 480
7 yy 70
8 tt 300
9 tt 150


上面是一个表 我希望一个SQL语句有下面这个效果

a b c
6 yy 480
8 tt 300
5 mm 120
2 ww 110

就是字段b不可以重复。。。。。谢谢 C字段排序很简单

[奇伢]

SELECT distinct(b) FROM table t order by t.c;

[lip009]

select *from table group by b order by c desc

[「已注销」]

select *from table group by b order by c desc
这个差不多，1楼我不太认可
个人意见

[lip009]

上面的没有得到最大值,这个OK
select *from (select a,b,max(c) as c from tab group by b) as t order by c desc;

[zuguanqun]

上面的这个ok

[esprit0318]

呵呵，来晚了！

[woowindice]

select max(a),b,max(c) from table group by b order by c desc

[SilenceSoul]

select *from (select a,b,max(c) as c from tab group by b) as t order by c desc;
这个OK

[qczl1224]

谢谢大家了，不过我问题还没解决 我的b字段是连表查的，我测试了N久都不行，单个表 group by 就可以了。。