How to display those employee whose joining of month and grade is equal?
SELECT enameFROM empWHERE sal BETWEEN (SELECT losal FROM salgrade WHERE grade = TO_CHAR(hiredate,’MM’) )AND (SELECT hisal FROM salgrade WHERE grade = TO_CHAR(hiredate,’MM’));