Re: Top N in Oracle 8.0.5

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 2 Jul 2002 22:30:02 +0100
Message-ID: <3d221b5e$0$8506$cc9e4d1f@news.dial.pipex.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:PMjU8.4622$68.82651_at_news4.srv.hcvlny.cv.net...
> I might be wrong ... and cannot test this .. but I remember using distinct
> clause to sort the subquery results.

Distinct doesn't guarantee an ordered resultset ONLY order by does. I'll agree that generally you'll get one but if you don't its just tough and that way unresolvable bugs lie.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Jul 02 2002 - 16:30:02 CDT