Consider the following relations:

empiempno, ename, age, job, salary, dob, doj, deptno$)$

Find empioyees who earns highest salary for their job

select ename, job, salary from emp

where $($job$,$ sal$)$ in$($select job, max$($sat$)$ from emp group by job$).$

select ename, job, salary from emp

where select job, max$($sal$)$ from emp group by job$).$

Both Band $C$

select ename, job, salary from emp

Where sat in $($setect maxisat$)$ from emp group by job$)$: