找重复按最大int_id删除重复

ztbsuper

于 2010-05-11 17:03:24 发布

阅读量110

点赞数

分类专栏：四川移动oss 文章标签： SQL

本文链接：https://blog.csdn.net/ztbsuper/article/details/83612506

版权

四川移动oss 专栏收录该内容

10 篇文章 0 订阅

订阅专栏


update rms_cell
set stateflag=to_char(sysdate,'yyyymmddhh24miss')
where int_id in(
select max(int_id)
from rms_cell where MCC||'-'||MNC||'-'||LAC||'-'||CI
in (
select MCC||'-'||MNC||'-'||LAC||'-'||CI
from RMS_CELL
where STATEFLAG=0
group by MCC||'-'||MNC||'-'||LAC||'-'||CI
having count(MCC||'-'||MNC||'-'||LAC||'-'||CI)>1
)
group by MCC||'-'||MNC||'-'||LAC||'-'||CI
)