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

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 Mon May 25 1998 - 00:00:00 CDT