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

Answer:

Both b and c

Hope it is helpful to you