关于group by的问题，谢谢！

[DCD]

a b c
1 2 2
2 2 3
2 3 4

我要得到，b相同的只留一个，按c排序

也就是这样：
a b c
1 2 2
2 3 4

b相同的好弄，可加上排序就不行了
select b from xxx group by b
如果加上order by c asc 就报错“不包含作为合计函数一部分的特定表达式”
应该是，最后得到2条数据，而不是3条，请高人指教！

[杨风79]

select * from tablename t where id in(select top 1 id from tablename where a=t.a order by c ) 'id为自动编号

[杨风79]

写错了，应该是：a改成b
select * from tablename t where id in(select top 1 id from tablename where b=t.b order by c ) 'id为自动编号

[pzhuyy]

select b,min(c) from #temp group by b order by min(c) desc

[littlelam]

select * from xxx where b in(select b from xxx group by b) order by c asc

[littlelam]

晕,写错了...

[littlelam]

pzhuyy(喝小酒泡尼姑) ( ) 信誉：100
正解