dokuwiki

This is an old revision of the document!

---

select last_name, department_id from employees where department_id = 50 or department_id = 60 

select first_name, 
       last_name, 
       salary from employees
where salary >= 10000 and
      salary <  15000
order by salary desc
select first_name, 
       last_name, 
       salary from employees
where salary in('10000',
'11000',
'13000'
)
order by salary desc


select first_name, 
       last_name, 
       salary from employees
where salary not between 10000 and 14000
and salary not in (10000, 14000)
order by salary desc