How to display those employee whose joining DATE is available in deptno?

Oracle Apps Interview Questions › Category: SQL › How to display those employee whose joining DATE is available in deptno?
0 Vote Up Vote Down
Questions Master asked 12 years ago

Display those employee whose joining DATE is available in deptno

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 12 years ago

SELECT ename FROM emp WHERE TO_CHAR(hiredate,’DD’)=deptno;