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

Fidel Cacheda Seijo wrote:
>
> 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

        Thank you for you solutions, but I'm trying to do it in SQL, without use PL/SQL.

        Any other idea??

                FY Received on Mon May 25 1998 - 00:00:00 CDT