This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
kurs:rownum [2012/09/25 17:22] 127.0.0.1 external edit |
kurs:rownum [2013/05/14 11:32] mh |
||
---|---|---|---|
Line 13: | Line 13: | ||
select rownum rn, first_name, last_name, salary from employees ) | select rownum rn, first_name, last_name, salary from employees ) | ||
where rn > 5 | where rn > 5 | ||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | 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 | ||
</code> | </code> |