Question

Consider the following relations: emp(empno, ename, age, job, salary, dob, doj, deptno) Find employees who earns highest salary for their job (A)select ename, job, salary from emp where sal in (select max(sal) from emp group by job); (B) select ename, job, salary from emp where (job, sal) in(select job, max(sal) from emp group by job); (C) select ename, job, salary from emp where (job, sal) = (select job, max(sal) from emp group by job); (D) Both B and C​

Answer 1

emp(empno, ename, age, job, salary, dob, doj, deptno) Find employees who earns highest salary for their job (A)select ename, job

t salary for their job (A)select ename, job, salary from emp where sal in (select max(sal) from emp group by job); (B) select ename, job, salary from emp where (job, sal) in(select job, max(sal) from emp group by job); (C) select ename, job, salary from emp