Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tarko
-
Rownum between on SQL statement
select * from dba_tables where rownum between 1 and 10 minus select * from dba_tables where rownum=1;- tarko
- Post #3
- Forum: Oracle: All versions
-
Rownum between on SQL statement
All the rows in your example will be the row number first, and due to that Oracle will skip all the rows. Perhaps you need Subqueries to workaround the problem.- tarko
- Post #2
- Forum: Oracle: All versions
