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