무회blog

* 다중컬럼 다중로우 문hr> 직무(job_id)별 최대급여자의 사원 내역을 출력하라 select max(salary),job_id from emp00 group by job_id ; select employee_id, last_name, salary, job_id from emp00 where (salary,job_id) IN (select max(salary),job_id from emp00 group by job_id) order by salary desc; --퀴즈 192> 01번 부서원들과 보너스(comm)가 같은 사원을 검색하라. select * from emp; select comm from emp where dno = '01'; select eno,ename, comm,dno from em..