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 Gob, sal) iln(select job, max(sal) from emp group by job);
(C) select ename, job, salary from emp
where Gob, sal) = (select job, max(sal) from emp group by job);
(D) Both B and C​

Answer 1

(A) select ename, job, salary from emp

where sal in (select max(sal) from emp group by job); ✅✅