Re: SQL Problem - Retrieving first n sorted rows

From: Ariel Kirson <arielk_at_dns.exlibris.co.il>
Date: Sun, 25 Oct 1998 10:32:14 +0200
Message-ID: <3632E20E.9580EF4E@dns.exlibris.co.il>

Hello there,

Thank you so much for the solution to my problem. Jurij's solutions work like a charm, however I don't really understand why.

I have tried both the outer join solution using the dual table, and the subselect solution, and for the life of me I can't figure out when the result is sorted, so as to return only the top N rows.

I would be very much obliged if you could post a short explanation of what the queries actually do.

Best regards,

Ariel Kirson
Ex Libris.

Matthias Gresz wrote:

> Hi,
>
> goto dejanews' archive and look for Jurij Modic's solution.
>
Received on Sun Oct 25 1998 - 02:32:14 CST