Re: OFFSET function in oracle
From: Christine <karistom_at_hotmail.com>
Date: 28 Nov 2003 02:47:29 -0800
Message-ID: <693b7163.0311280247.118c32ed_at_posting.google.com>
Date: 28 Nov 2003 02:47:29 -0800
Message-ID: <693b7163.0311280247.118c32ed_at_posting.google.com>
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.