Re: GROUP BY question

From: Carlos Bromanski <cbroman_at_shpamcore.com>
Date: Thu, 19 Apr 2001 00:37:10 -0500
Message-ID: <3ade7916$0$42880$1dc6e903@news.corecomm.net>

the tao is humble
unless it proves incorrect
then it is silent
>:-)

Todd Gillespie <toddg_at_linux127.ma.utexas.edu> wrote in message news:9blk79$lo1$1_at_geraldo.cc.utexas.edu...
> Carlos Bromanski <cbroman_at_shpamcore.com> wrote:
> : SELECT Whse, CustPN, Price
> : FROM ThatTable AS A
> : WHERE Price = (
> : SELECT max(Price), CustPN
> : FROM ThatTable AS B
> : WHERE B.CustPN = A.CustPN
> : GROUP BY CustPN)
>
> Your kung-fu is the best.
>
Received on Thu Apr 19 2001 - 00:37:10 CDT