例如 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 阅读(161)
评论(0) 编辑 收藏 所属分类:
Oralce&&PL/SQL