专题文章
时长:00:00更新时间: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
查看详情