Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!feeder.news-service.com!news.albasani.net!.POSTED!not-for-mail From: Lew Newsgroups: comp.lang.java.programmer Subject: Re: SQL Puzzle - too many dimensions Date: Sun, 08 May 2011 08:08:24 -0400 Organization: albasani.net Lines: 25 Message-ID: References: <92nbumFrggU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Trace: news.albasani.net 2ZMd0fSaCrUle+wDtvgG0VPl9upwrlDjAGcR6YW/hGW+57BMoxySKXmFdI22ZdPc7TjH2EKy7yRvsTW0mrBj7A== NNTP-Posting-Date: Sun, 8 May 2011 12:08:20 +0000 (UTC) Injection-Info: news.albasani.net; logging-data="j8SymvxoZkaW+EdCwCqIrzq26S+pBj30d8CMiPHawjhi8Lo7jyBy6/6AY49S9/FEhodt1pePO5MgdaNMKUkrXzIHKG4d3drnJhukzj8dwe/NZrRS+34yWgyYy7P5gMkk"; mail-complaints-to="abuse@albasani.net" User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 In-Reply-To: Cancel-Lock: sha1:s3X01eQKrpBgHOLR0YBwJrKYtMM= Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:3810 On 05/08/2011 08:01 AM, Lawrence D'Oliveiro wrote: > In message<92nbumFrggU1@mid.individual.net>, Robert Klemme wrote: > >> On 08.05.2011 04:00, Lawrence D'Oliveiro wrote: >> >>> In message, wrote: >>> >>>> But anyway, this is in an Oracle DB, and they don't let you include >>>> columns in a group-by query that aren't explicitly group-by that way. >>> >>> Sounds like as good a time as any to move away from Oracle. >> >> That's ridiculous. This query can be easily done with Oracle. > > That wasn’t quite what I meant. Perhaps if you said what you actually meant, or even made sense, instead of dropping these trollish fragments to maintain plausible deniability and the ability to argue with whatever answer you get, that would be less insufferably rude than what you are doing. -- Lew Honi soit qui mal y pense. http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg