kurs:rownum
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
kurs:rownum [2012/09/25 17:22] 127.0.0.1 external edit |
kurs:rownum [2014/09/10 21:22] 127.0.0.1 external edit |
||
|---|---|---|---|
| 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> | ||
kurs/rownum.txt ยท Last modified: 2015/10/27 09:42 by mh
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
