oracle rowid会重复吗,ORACLE 中rowid查询重复记录的sql语句分析_炸酱李的博客

SQL  语句

SELECT ROWID,EMPNO,JOB FROM EMP WHERE ROWID!=(SELECT MAX(ROWID) FROM EMP D WHERE EMP.JOB=D.JOB)ORDER BY JOB;SELECT ROWID,EMPNO,JOB FROM EMP