Re: a SQL quiz

From: <shiling_at_math.wayne.edu>
Date: Sat, 29 May 1999 19:26:12 GMT
Message-ID: <7ipf0k$h8g$1@nnrp1.deja.com>

In article <374FD4B5.4372FADB_at_online.de>, BM Lam <1116-530_at_online.de> wrote:
> Dies ist eine mehrteilige Nachricht im MIME-Format.
> --------------F7C74B1C2D739127ED00E09C
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> That does not work on my system. And stupid me, I have tested a
working solution
> posted by OracleNet but forgot to save it on disk. And now I cant get
syntax
> right again.
>
> Does anyone remember the solution?
>

I saved a copy.

It is called a pair comparison. It's really good.

select a.item, a.month, a.price
from temp a
where (a.item, a.month) in (select item, max(month) from temp group by tem )

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat May 29 1999 - 14:26:12 CDT