I have a table where salary is a field with integer type.
I have values like
Now my query is like
select * from job_list where type='Temporary' or type='Contract' and salary>='10000' and salary<='30000' order by salary desc
Ihave tried this above query with BETWEEN too but still fetching 1 row where it should fetch 0 row
Please suggest as I am really astonished.