SELECt * FROM (SELECt A.*, ROWNUM rn FROM (
select DEP.*, DET.DET_NAME, DET1.DET_NAME
from NORMAL.TB_DEPARTMENT DEP, NORMAL.TB_DETAIL DET, NORMAL.TB_DETAIL DET1
where 1=1 and DEP.DEP_TYPE = DET.DET_ID and DEP.DEP_LEVEL = DET1.DET_ID
) A WHERe ROWNUM <= 10) WHERe rn >= 1
如此..如何区分同名列