I wanna show employee whose getting salary 10000 to 20000

[#1]

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..

[MayilVahanan · Accepted solution]

Hi

Try like this

If(SALARY >= 10000 AND SALARY <= 20000, EMPLOYEE_ID) as Grade2

[#3]

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.........

[MayilVahanan]