How to display the names of the employees who are working in the company for the past 5 years?

Oracle Apps Interview Questions › Category: SQL › How to display the names of the employees who are working in the company for the past 5 years?

0 Vote Up Vote Down

Questions Master asked 10 years ago

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

SELECT ename
FROM emp
WHERE TO_CHAR(sysdate,’YYYY’)-TO_CHAR(hiredate,’YYYY’)>=5;