delete from t_user t where 1=1 and exists(
select 1 from (
select a.pid , a.rowid from (
select t.* ,row_number() over(partition by t.pid order by t.pid) nm
from t_user t ) a
where a.nm>1
order by a.pid
) b where b.rowid = t.rowid
)
删除一次插入多条重复的数据,只留一条,删除前先备份表,以防删除错误
exists运算符用于判断查询子句是否有记录,如果有一条或多条记录存在返回 True,否则返回 False。