Find all employee salary for last 90 days where salary is between 70,000 and 100,000
plz write the syntax
Thanks
Printable View
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;