|
1.如果有ID字段，就是具有唯一性的字段
<div class="codetitle"><a style="CURSOR: pointer" data="71195" class="copybut" id="copybut71195" onclick="doCopy('code71195')"> 代码如下:<div class="codebody" id="code71195">
delect table where id not in (
select max(id) from table group by col1,col2,col3...
)
group by 子句后跟的字段就是你用来判断重复的条件，如只有col1，那么只要col1字段内容相同即表示记录相同。 2. 如果是判断所有字段也可以这样
<div class="codetitle"><a style="CURSOR: pointer" data="62909" class="copybut" id="copybut62909" onclick="doCopy('code62909')"> 代码如下:<div class="codebody" id="code62909">
select into #aa from table group by id1,id2,....
delete table
insert into table
select from #aa
3. 没有ID的情况
<div class="codetitle"><a style="CURSOR: pointer" data="40883" class="copybut" id="copybut40883" onclick="doCopy('code40883')"> 代码如下:<div class="codebody" id="code40883">
select identity(int,1,1) as id, into #temp from tabel
delect # where id not in (
select max(id) from # group by col1,col3...)
delect table
inset into table(...)
select ..... from #temp
4. col1+','+col2+','...col5 联合主键
<div class="codetitle"><a style="CURSOR: pointer" data="80404" class="copybut" id="copybut80404" onclick="doCopy('code80404')"> 代码如下:<div class="codebody" id="code80404">
select from table where col1+','...col5 in (
select max(col1+','...col5) from table
where having count()>1
group by col1,col3,col4
)
group by 子句后跟的字段就是你用来判断重复的条件，如只有col1，那么只要col1字段内容相同即表示记录相同。 5.
<div class="codetitle"><a style="CURSOR: pointer" data="61841" class="copybut" id="copybut61841" onclick="doCopy('code61841')"> 代码如下:<div class="codebody" id="code61841">
select identity(int, into #temp from tabel
select from #temp where id in (
select max(id) from #emp where having count()>1 group by col1,col3...)
6.
<div class="codetitle"><a style="CURSOR: pointer" data="44087" class="copybut" id="copybut44087" onclick="doCopy('code44087')"> 代码如下:<div class="codebody" id="code44087">
select distinct into #temp from tablename
delete tablename
go
insert tablename select from #temp Sqlclub
go
drop table #temp
以上就是SQL Server删除重复行的方法介绍。 （编辑：莱芜站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
