dokuwiki

This is an old revision of the document!

---

select first_name, last_name, salary from employees where
department_id in  
  (select i from 
     (select department_id i, count(*) from employees
      group by department_id 
      having count(*) >= 5)
   )

select rownum, rn, first_name, last_name, salary from (
select rownum rn, first_name, last_name, salary from employees )
where rn > 5

select * from (
select rownum r, 
       first_name, 
       last_name,
       salary 
 from (
  select first_name, 
       last_name,
       salary
       from employees
       order by salary desc
 )
 ) where r > 5