Re: SQL question
From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 02 Nov 2000 14:47:05 GMT
Message-ID: <3a017e28.176508140_at_news.alt.net>
Date: Thu, 02 Nov 2000 14:47:05 GMT
Message-ID: <3a017e28.176508140_at_news.alt.net>
On Thu, 2 Nov 2000 15:05:35 +0100, "Rafa³ Jank" <yankee_at_wp.pl> wrote:
>I don't think that will work. The problem is that rownum < 4 in that function is
>executed BEFORE order by, so that list won't be properly ordered. Remove that
>AND ROWNUM <4 and it should do the trick.
>Rafal
>
Ooh, forgot about that. I was fine until I tried optimizing it. :-)
I was curious if it could be done without a function.
Brian Received on Thu Nov 02 2000 - 15:47:05 CET