Oracle_语句

Oracle删除 字段值完全相同的记录，直留一条：
delete from fuhe a where rowid > (select min(rowid) from fuhe b where a.KaiGuanDuan=b.KaiGuanDuan and a.RongLiangPercent=b.RongLiangPercent and a.hz=b.hz and a.P=b.P and a.Q=b.Q);

 

 

Z

 

Oracle_语句

标签：数据   int   color   ber   date   order by   art   字段   完全