Re: OFFSET function in oracle
From: Christine <karistom_at_hotmail.com>
Date: 27 Nov 2003 23:59:34 -0800
Message-ID: <693b7163.0311272359.27eeac68_at_posting.google.com>
Date: 27 Nov 2003 23:59:34 -0800
Message-ID: <693b7163.0311272359.27eeac68_at_posting.google.com>
"Guido Konsolke" <GK_at_oblivion.com> wrote in message news:<1069407632.827289_at_news.thyssen.com>...
> "Christine" <karistom_at_hotmail.com> wrote...
> > this may help you ....
> >
> > select * from mytable where rownum <= 20
> > minus
> > select * from mytable where rownum <= 10
>
> Hi Christine,
>
> you're kidding, right?
this should work ->
select rownum, * from mytable where rownum <= 20
minus
select rownum, * from mytable where rownum <= 10
Received on Fri Nov 28 2003 - 08:59:34 CET