Oracle 9i 입니다.
SQL에서
select
ename,to_char(sal,'999,990') as 연봉,
to_char(hiredate,'yyyy"년"mm"월"dd"일"') as 입사일,
deptno from emp where sal in(
select max(sal) from emp group by deptno)
order by deptno asc;
결과는....
ENAME 연봉 입사일 DEPTNO
KING 5,000 10
Luna 5,000 10
Kim 6,