Thread: Sql

Find all employee salary for last 90 days where salary is between 70,000 and 100,000

plz write the syntax

Thanks

could be you more especific? with rmdbs and what are the tbale fileds?
if you table had a salary pay day the select could be this

select salary
from salary_table
where salary between 70000 and 100000
and salary_pay_day between today-90 and today

HTH

Hi,
syntax for query is:-

select salary from emp_table where salary between 70000 and 100000
and salary_4_day between sysdate-90 and sysdate;