Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: top N or rewriting MAX

Re: top N or rewriting MAX

From: ZEITGEIST <restaurant_at_the.end.of.the.universe>
Date: 1997/01/17
Message-ID: <5bmo37$327@news1.ee.net>#1/1

In article <32DA094D.1D38_at_adra.se>, roger.wernersson_at_adra.se says...
>

* question and answer snipped *

>You stupid! You are dead wrong! It is much simpler to create a view with
>a GROUP BY clause and then use ROWNUM to get the lowest values, though
>you might be in for some trouble if you want the highest ones.
>
 

>Mailto:roger.wernersson_at_adra.se
>BTW: All opinions are mine, all mine, and nobody's but mine.

I'm glad this nasty opinion is yours alone. It really stinks up the NG. Perhaps your future contributions could be less caustic.

Brett
zgeist_at_ee.net Received on Fri Jan 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US