Re: GROUP BY question
From: Todd Gillespie <toddg_at_linux127.ma.utexas.edu>
Date: 19 Apr 2001 02:57:45 GMT
Message-ID: <9blk79$lo1$1_at_geraldo.cc.utexas.edu>
Date: 19 Apr 2001 02:57:45 GMT
Message-ID: <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 - 04:57:45 CEST