[简单问题]去掉表中的重复数据

[aspxcss]

表中的数据如下
ID LeiXing
1 aa
2 bb
3 cc
4 dd
5 bb
希望得到的结果是
ID LeiXing
1 aa
2 bb
3 cc
4 dd
环境是SQL Server,如何弄？？？？

[ralpha08]

select ID=identity(int,1,1),t.* into #temp from(select distinct LeiXing from table)t;
select * from #temp

[aspxcss]

... ...

[wengnet]

select * from tab where LeiXing in (select distinct LeiXing from tab )

[aspxcss]

不行啊.还是显示出了所有的LeiXing,没有过滤重复的.

[ralpha08]

select min(ID),LeiXing from tab group by LeiXing

[aspxcss]

select min(ID),LeiXing from tab group by LeiXing

没有取出ID字段啊.

[macong]

select distinct leixing from table

[ralpha08]

select min(ID) as ID,LeiXing from tab group by LeiXing

[aspxcss]

select min(ID) as ID,LeiXing from tab group by LeiXing

OＫ了,min(ID)是啥意思,还有group by,谢谢.

[ralpha08]

只取最小ID ,group by 分组显示

[hegang888888888]

select min(ID) as ID,LeiXing from tab group by LeiXing