How to display the names of clerks who earn a salary more than the lowest salary of any salesman?

Oracle Apps Interview Questions › Category: SQL › How to display the names of clerks who earn a salary more than the lowest salary of any salesman?

0 Vote Up Vote Down

Questions Master asked 10 years ago

How to display the names of clerks who earn a salary more than the lowest salary of any salesman?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

SELECT ename
FROM emp
WHERE job=’CLERK’
AND sal >
(SELECT MIN(sal) FROM emp WHERE job=’SALESMAN’
);