sql重复语句
0
所有回答(4)
0
//1.查询满足条件的大于1条的数据
select *frmo table where count(name)>1 and count(tel)>1;
//2.通过row_number() over对上面数据进行重新排序,得到一个从1开始的序号Rid
//3.update Rid>1的数据 修改状态为1
0
？？？？？会distinct
0
update table c, (SELECT name,phone,min(id) as a FROM table GROUP BY name,phone ) t
set c.zt='1'
WHERE c.name = t.name AND c.phone = t.phone
and c.id <> t.a
0
UPDATE 表1 set 状态 = 1 where ID in(
select max(ghk_ID) from 表1 as h1
where (select COUNT(*) from 表1 as h2 where h2.重复字段1=h1.重复字段1 and h2.重复字段2=h1.重复字段2 )>1
group by 重复字段1,重复字段2)
