User Tools

Site Tools


kurs:rownum

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
kurs/rownum.1410376975.txt.gz · Last modified: 2015/10/27 09:42 (external edit)