删除表中重复记录大于两条保存两条

来源：懂视网责编：小采时间：2020-11-09 16:10:16

删除表中重复记录大于两条保存两条

删除表中重复记录大于两条保存两条:delete from t_Cht_clm_reg F where F.case_id in ( select T.case_id from ( select B.* from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn from t_Cht_clm_reg e) B where B.notice_id in( select A.notice_id

推荐度：

点击下载本文 文档为doc格式

导读删除表中重复记录大于两条保存两条:delete from t_Cht_clm_reg F where F.case_id in ( select T.case_id from ( select B.* from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn from t_Cht_clm_reg e) B where B.notice_id in( select A.notice_id

delete from t_Cht_clm_reg F where F.case_id in (
select T.case_id from (
select B.* from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn
from t_Cht_clm_reg e) B where B.notice_id in(
select A.notice_id from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn
from t_Cht_clm_reg e) A group by A.notice_id having count(A.notice_id) > 2 )
) T where T.RN > 2 )

<无> $velocityCount-->

delete from t_Cht_clm_reg F where F.case_id in (
select T.case_id from (
select B.* from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn 
 from t_Cht_clm_reg e) B where B.notice_id in(
select A.notice_id from (select e.* , row_number() over (partition by e.notice_id order by e.case_id desc) rn 
 from t_Cht_clm_reg e) A group by A.notice_id having count(A.notice_id) > 2 )
 ) T where T.RN > 2 )

删除表中重复记录大于两条保存两条

推荐度：

点击下载本文 文档为doc格式

标签：保存删除记录

热门焦点

删除表中重复记录大于两条保存两条

删除表中重复记录大于两条保存两条

删除表中重复记录大于两条保存两条

最新推荐

猜你喜欢

热门推荐