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