Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
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..
Hi
Try like this
If(SALARY >= 10000 AND SALARY <= 20000, EMPLOYEE_ID) as Grade2
Hi
Try like this
If(SALARY >= 10000 AND SALARY <= 20000, EMPLOYEE_ID) as Grade2
Dude Really thank you very much I got my output. I know very well I was struggle with this '&' in that expression. Now am very cleared once again thank you dude.........