Consider the following relations: emp(empno, ename, age, job, salary, dob, doj, deptno) Find employees who earns...

Transcribed Image Text:

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 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 rating: 100% (QA)

All the answers generate an error due to a typo However if you replace sal ... View the full answer