use database_name
selet all from table_name
把得到的记录复制一份，粘贴到原表
在把表的字段属性中给编号字段加个主键约束 primery key
㈡ sqlserver 去掉重复记录
首先设定表tb_a 唯一关键字段 xh,以及要查询的重复字段 mc 则查询mc重复的sqlserver语句如下
select mc from tb_a where xh not in (select min(xh) xh from tb_a group by mc)
㈢ 求帮助，sqlserver去除重复行
就是要每组最新一条数据呗
select * from tb t where not exists(select 1 from tb where t.name=name and time>t.time)
㈣ SQLServer去重复查询，不删除重复数据
1、要有定位基准，也就是说，你的表必需要有一个不重复的键值，如果没有，请你给这个表加一个字段，将这个字段设为自增变量字段，建议为int类型，比如字段名可为“编码”。
2、查重复的数据：
select*from表名where编码in
(select编码from表名groupby编码havingcount(1)>=2)
3、删除所有有重复的记录：
deletefrom表名where
编码in(select编码from表名groupby编码havingcount(1)>=2)
4、删去重复的，只留下重复记录中编码最大的一条：
deletefrom表名where
编码in(select编码from表名groupby编码havingcount(1)>=2)
and编码notin(selectmax(编码)from表名groupby编码havingcount(1)>=2)
㈤ sqlserver 怎样将所有的字段去掉重复的数据
找到最大的rowid即可。
Sql代码：
alter proc getNotDupData
as
--clear temp table
delete ODS.dbo.Agent
delete from stage.dbo.tmpDup
delete from stage.dbo.tmpRowNo
delete from stage.dbo.tmpMaxRowNo
--create p table
insert into stage.dbo.tmpDup
select distinct AgentLogin,AgentSurName,AgentGivenName from stage.dbo.dAgentPerformanceStat
where AgentSurname is not null and agentlogin like '3%' order by AgentLogin
--add rowNo
insert into tmpRowNo
select *,ROW_NUMBER()over(order by AgentLogin) as rowno from tmpDup
--get max rowno
insert into stage.dbo.tmpMaxRowNo
select max(rowno) as 'rowno' from stage.dbo.tmpRowNo group by AgentLogin having count(*)>1
--remove max rowno
delete from stage.dbo.tmpRowNo where rowno in (select * from stage.dbo.tmpMaxRowNo)
--insert into ods
insert into ODS.dbo.Agent select AgentLogin,AgentSurName,AgentGivenName from stage.dbo.tmpRowNo
㈥ sqlserver2005中怎么删除重复记录,只留一条记录
可以试一下 增加个自增列（fid）字段 然后按照某字段排组一下删除最大的或者最小的fid
㈦ SQLSERVER 怎样去除重复记录
distinct关键字
select distinct 姓名 from 表a
这条语句在显示时可以提取表a中的姓名，而且如果姓名重复的话，只显示一条，单并不对数据库中的数据产生影响，只是显示的时候重复的记录只显示一条
㈧ sqlserver怎么删除重复数据
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select
* from people
where peopleId in (select peopleId from
people group by peopleId having count(peopleId)
> 1)
2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录
delete
from people
where peopleId in (select peopleId from
people group by peopleId having
count(peopleId) > 1)
and rowid not in (select min(rowid) from
people group by peopleId having count(peopleId
)>1)
3、查找表中多余的重复记录（多个字段）
select * from vitae a
where (a.peopleId,a.seq)
in (select peopleId,seq from vitae group by peopleId,seq having
count(*) > 1)
4、删除表中多余的重复记录（多个字段），只留有rowid最小的记录
delete from vitae a
where
(a.peopleId,a.seq) in (select peopleId,seq from vitae group by
peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from
vitae group by peopleId,seq having count(*)>1)
5、查找表中多余的重复记录（多个字段），不包含rowid最小的记录
select * from vitae a
where
(a.peopleId,a.seq) in (select peopleId,seq from vitae group by
peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from
vitae group by peopleId,seq having count(*)>1)
(二)
比方说
在A表中存在一个字段“name”，
而且不同记录之间的“name”值有可能会相同，
现在就是需要查询出在该表中的各记录之间，“name”值存在重复的项；
Select
Name,Count(*) From A Group By Name Having Count(*) > 1
如果还查性别也相同大则如下:
Select Name,sex,Count(*) From A Group By Name,sex Having
Count(*) > 1
㈨ sqlserver 排除重复数据
select a.* from queueabandon a inner join (select min(callid) callid from queueabandon group by callid) b on a.callid=b.callid