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_at_news.corecomm.net>
Date: Thu, 19 Apr 2001 00:37:10 -0500
Message-ID: <3ade7916$0$42880$1dc6e903_at_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 - 07:37:10 CEST