如何去掉某个字段的重复记录

[liyanhuacau]

数据全部重复，如下图：



需要得到以下的结果：



sql该如何写，各位帮看看 谢谢

[jiangshun]

distinct

[wujinyuan]

select distinct * from tb

[冷箫轻笛]

select distinct id,name from tablename

[liyanhuacau]

关键我现在要取前几条 我这样写select top(2) distinct id,name from tablename 有错误

[liyanhuacau]

而且这样写好像也去除不了某字段的重复信息

[wujinyuan]

select distinct * from (select top(2) distinct id,name from tablename) a

[虫洞]

select top(2)id,name 
from (select distinct id,name from tablename )t

[阿彪兄]

distinct就可以了啊

[ask_chang]

1> 显示去掉
select distinct * from tb


2>数据库去掉

select distinct * into #t from tb

select * from #t

truncate table tb

select * into tb from #t

注意里面没有identity字段。

[andy_liucj]

select top(2) id,name 
from (select distinct id,name from tablename ) as t

[jsjwlxh]

[Quote=引用 9 楼 ask_chang 的回复:]
1> 显示去掉
select distinct * from tb


2>数据库去掉

select distinct * into #t from tb

select * from #t

truncate table tb

select * into tb from #t

注意里面没有identity字段。
[/Quote]


--------
UP

[da21]

9楼的OK
也可以用cursor 然后将非第一次出现的id,name对应的记录删除掉

[一切为了你]

distinct 去除重复数据的关键词

[xuyanwei_love]

distinct 就可以实现吧 试下

[xyj052]

显示的话，直接用DISTINCT就可以了