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

From: Fidel Cacheda Seijo <fidel_at_cesat.es>
Date: 1998/05/25
Message-ID: <35696731.9E238DE3_at_cesat.es>#1/1


Hello,

[Quoted]         I'm newbie, but I think this is not a very easy question. I've been [Quoted] [Quoted] thinking about it some time, but I can't get any solution.

[Quoted]         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 Mon May 25 1998 - 00:00:00 CEST

Original text of this message