Re: OFFSET function in oracle

how come i can't delete my meg???
THIS should work, really... ->
 
 select rownum, col1, col2 ... from mytable where rownum <= 20
 minus
 select rownum, col1, col2 ...  from mytable where rownum <= 10


* replace (col1, col2 ...) to whatever colname you want to select.