How to display those employee whose joining of month and grade is equal?

Oracle Apps Interview Questions › Category: SQL › How to display those employee whose joining of month and grade is equal?
0 Vote Up Vote Down
Questions Master asked 9 years ago

How to display those employee whose joining of month and grade is equal?

1 Answers
0 Vote Up Vote Down
Questions Master answered 9 years ago

SELECT ename
FROM emp
WHERE sal BETWEEN
(SELECT losal FROM salgrade WHERE grade = TO_CHAR(hiredate,’MM’)
)
AND (SELECT hisal FROM salgrade WHERE grade = TO_CHAR(hiredate,’MM’));