DELETE FROM abc
WHERE ROWID IN (SELECT r
FROM (SELECT t.ROWID r,
ROW_NUMBER( )
OVER ( PARTITION BY empno, ename, job
ORDER BY empno, ename, job )
id
FROM abc t)
WHERE id <> 1);
create table abc2 as select empno,ename,job from abc group by empno,ename,job;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21492320/viewspace-1058852/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21492320/viewspace-1058852/