Question

oracle数据库中有多行相同数据,只留一行怎么实现?

Answer 1

DELETE FROM EMP E WHERE E.ROWID > (SELECT MIN(X.ROWID)
FROM EMP X WHERE X.EMP_NO = E.EMP_NO);

Answer 2

select distinct col1,col2,col3 from table

Answer 3

distinct 关键字帮你解决这个问题。

Answer 4

distinct 函数查询出来 插入另一张表 最简单了