Re: tricky queries

Hi,

take a look at dejanews archive for Jurij Modic's Top-X or Top N solution.

segoro_at_my-dejanews.com schrieb:
>
> Hello All!
> Who knows
> how I can Select __five maximal__ or N MAXIMAL values from complex SubQuery.
>
> SELECT ID, DATA FROM (SUBQUERY)
> wHERE ID = ( Select MAX( ID ) from (SUBQUERY) )
>
> Returns One MAXIMAL Value, but SubQuery runs Twice!
> How about FIVE???
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Mon Feb 22 1999 - 09:29:12 CST