User Tools

Site Tools


kurs:zeilen_vergleichen
select  a.employee_id, a.first_name, a.last_name, a.salary,
        b.employee_id, b.first_name, b.last_name, b.salary
--       ,       prior a.salary
  from 
  (select employee_id, first_name, last_name, salary 
    from employees order by salary desc, employee_id) a,  
  ( 
     (select  employee_id, first_name, last_name, salary 
        from employees)
       minus 
     select * from 
     (select employee_id, first_name, last_name, salary 
     from employees order by salary desc) where rownum<2 
   ) b
 where  b.employee_id(+) = a.employee_id
kurs/zeilen_vergleichen.txt · Last modified: 2014/09/10 21:22 (external edit)