dokuwiki

This is an old revision of the document!

---

einfache selects

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