知其然(1) 无法使用 DISTINCT, GROUP BY 等子句从视图中选择 ROWID 或采样

select * from
(SELECT ROWID, ROWNUM R,ENAME FROM EMP WHERE SAL>2000)
where 3 <= R and R <= 5; 

报错:

ORA-01446: 无法使用 DISTINCT, GROUP BY 等子句从视图中选择 ROWID 或采样
01446. 00000 -  "cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc."
*Cause:    
*Action:
行 1 列 8 出错

改为:对ROWID重命名为RID

select * from
(SELECT ROWID RID, ROWNUM R,ENAME FROM EMP WHERE SAL>2000)
where 3 <= R and R <= 5; 

结果: