How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?

Oracle Apps Interview Questions › Category: SQL › How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?

0 Vote Up Vote Down

Questions Master asked 10 years ago

How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

SELECT ename FROM emp WHERE job=’CLERK’ AND 12*(sal+NVL(comm,0))>3000;