From: Todd Gillespie <toddg@linux127.ma.utexas.edu>
Newsgroups: comp.databases.theory
Subject: Re: GROUP BY question
Date: 19 Apr 2001 02:57:45 GMT
Organization: The University of Texas at Austin; Austin, Texas
Lines: 14
Message-ID: <9blk79$lo1$1@geraldo.cc.utexas.edu>
References: <3ade0e70$0$14446$272ea4a1@news.execpc.com> <3ade40cb$0$12821$1dc6e903@news.corecomm.net>
NNTP-Posting-Host: linux127.ma.utexas.edu
X-Trace: geraldo.cc.utexas.edu 987649065 22273 146.6.139.98 (19 Apr 2001 02:57:45 GMT)
X-Complaints-To: abuse@cc.utexas.edu
NNTP-Posting-Date: 19 Apr 2001 02:57:45 GMT
User-Agent: tin/pre-1.4-19990805 ("Preacher Man") (UNIX) (Linux/2.2.17 (i686))


Carlos Bromanski <cbroman@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.