delete from proj_info where newcode in (select newcode from proj_info group by newcode having count(newcode) > 1) and NID not in (select min(nid) from proj_info group by newcode having count(newcode)>1)
本文共 258 字，大约阅读时间需要 1 分钟。
delete from proj_info where newcode in (select newcode from proj_info group by newcode having count(newcode) > 1) and NID not in (select min(nid) from proj_info group by newcode having count(newcode)>1)
转载于:https://www.cnblogs.com/xinxinzhihuo/p/5663351.html