对数据库某些意外情况,引起的重复数据,如何处理呢?
----------------查重复:
select *
from satisfaction_survey s
where s.as_side = 0
and s.project_no in (select ss.project_no
from satisfaction_survey ss
where ss.as_side = 0
group by ss.project_no
having count(*) > 1)
order by s.project_no, s.submit_time
思路:从预先选出的数据中(s.as_side = 0),根据特定字段(s.project_no),判断是否存在(count(*) > 1,符合条件的数据不止一条)重复数据
当然,也可以根据多个字段(in 前面的字段,用个括号括起来,in select子句的返回字段对应改变)判断是否存在重复数据
----------------------去重复:
delete from satisfaction_survey s
where s.as_side = 0
and(s.project_no/*, to_char(s.submit_time, 'yyyy-mm-dd')*/) in
(select ss.project_no/*, to_char(ss.submit_time, 'yyyy-mm-dd') */
from satisfaction_survey ss
where ss.as