How to display those employee whose 10% of salary is equal to the year of joining?

Oracle Apps Interview QuestionsCategory: SQLHow to display those employee whose 10% of salary is equal to the year of joining?
Questions Master asked 10 years ago

How to display those employee whose 10% of salary is equal to the year of  joining?

1 Answers
Shailender Thallam Staff answered 10 years ago

SELECT ename FROM emp WHERE TO_CHAR(hiredate,’YY’)=sal*0.1;