表中有A列和B列，对A列数据去重复，对B列数据排序

declare @tt  table(a int,b int);insert into @tt values (11,12),(13,13),(11,30),(14,50),(23,12);select * from @tt;select * from (select a,MIN(b) bb from @tt group by a )tab order by bb;或者 select a,MIN(b) as bb from @tt group by a order by bb;