Re: OFFSET function in oracle

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 21 Nov 2003 06:25:50 -0800
Message-ID: <1a8fec49.0311210625.2947b28b_at_posting.google.com>


Well write a little PL/SQL and do it yourself. It might look less efficient than SQL Server, but that's pretty much what it does internally.

ETA "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?
Received on Fri Nov 21 2003 - 15:25:50 CET

Original text of this message