select * from employee where ((empsalary>20000) and (empsalary<30000));