例如 STUDENT 表中 有字段 NAME。刪除其中重復記錄
delete from student where rowid NOT IN (select max(rowid) from student group by name);
delete from student x where rowid NOT IN (select max(rowid) from student y where x.name = y.name );
posted on 2006-12-01 20:16
JavaCoffe 閱讀(302)
評論(0) 編輯 收藏 所屬分類:
Oralce&&PL/SQL