This content has been marked as final. Show 3 replies
I wanna show the employee_id whose getting salary in between 10000 to 20000 And am using this expression for that.
If(((SALARY<=20000)&(SALARY>=10000)),EMPLOYEE_ID )as Grade2
But it show me the employee id whose are getting salary below 20000 and below 10000 also ..
Can u please help me to get my required output..