Rowid로 데이터 찾기 - 첫번째 방법 : 일반적 방법 select deptno, max(hiredate) as max_hiredate from emp group by deptno; select * from emp e, (select deptno, max(hiredate) as max_hiredate from emp group by deptno) d where e.deptno = d.deptno and e.hiredate = d.max_hiredate; - 두번째 방법 : Join 할 때 직접 rowid를 활용하는 방법 select deptno, to_char(hiredate,'YYYYMMDD')||ROWID as rid from emp order by deptno, rid; select deptno,..