Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!.POSTED!not-for-mail From: Roedy Green Newsgroups: comp.lang.java.programmer Subject: Re: SQL Puzzle - too many dimensions Date: Sat, 07 May 2011 23:36:13 -0700 Organization: Canadian Mind Products Lines: 17 Message-ID: <7becs6h10lufrqvb8ciii7vpafjqldv3f0@4ax.com> References: Reply-To: Roedy Green NNTP-Posting-Host: RCd/Ul4tyxGUBII8WGwa5g.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org X-Notice: Filtered by postfilter v. 0.8.2 X-Newsreader: Forte Agent 6.00/32.1186 Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:3795 On Sat, 07 May 2011 23:32:09 -0700, Roedy Green wrote, quoted or indirectly quoted someone who said : > >Find the max, then do a query for match on that max value. You need to combine these into one query, otherwise the max could change just prior to the second query. -- Roedy Green Canadian Mind Products http://mindprod.com How long did it take after the car was invented before owners understood cars would not work unless you regularly changed the oil and the tires? We have gone 33 years and still it is rare to uncover a user who understands computers don't work without regular backups.