Re: Obtains rows 10-20 in a SELECT with ORDER BY!

From: Bryan Michael Lenihan <bryanle_at_lenisoft.com>
Date: 1998/05/26
Message-ID: <6kdh9p$1rr$1@news1.infoave.net>#1/1

If you are Oracle 7.2 or higher you can also use this

select cola, colb from
(select rownum rn, cola, colb from tablea) where rn between 10 and 20
/

Fidel Cacheda Seijo wrote in message <35696731.9E238DE3_at_cesat.es>...
>Hello,
>
> I'm newbie, but I think this is not a very easy question. I've been
>thinking about it some time, but I can't get any solution.
>
> The problem is easy: in a SELECT that returns 100 rows (for example), I
>just need rows from 10 to 20. This is easy to do, but the problem is
>that I need that the query performs first the ORDER BY, and then obtain
>the rows I want.
>
> Any idea??
>
> FY
Received on Tue May 26 1998 - 00:00:00 CDT