oracle查询删除重复记录 删除deletefromupsrdictdtlwhereidin(selectidfrom(selecta。,rownumber()over(partitionbydictno,optcode,optnameorderbyoptcode)rnfromupsrdictdtlawheredictnoPC1814)bwherern2) 查询selectfromupsrdictdtlwhereidin(selectidfrom(selecta。,rownumber()over(partitionbydictno,optcode,optnameorderbyiddesc)rnfromupsrdictdtlawheredictnoDPATIDTYPEDG)bwherern2) 删除deletefromupsrdp。tableduzhaozhaocwhererowidnotin(selectmin(rowid)max(rowid)fromupsrdp。tableduzhaozhaoagroupbyprdunum) rowid删除记录deletefromupsrdp。TABLEDUZHAOZHAOwhererowidAAAaGcAAHAAGyYjAAB 202258