Display those employee whose joining of month and grade is equal.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 684
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'));

Comments or Responses

Login to post response