Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!matrix.darkstorm.co.uk!news.unit0.net!news.glorb.com!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail
From: Lawrence D'Oliveiro <ldo@geek-central.gen.new_zealand>
Newsgroups: comp.lang.java.programmer
Subject: Re: SQL Puzzle - too many dimensions
Followup-To: comp.lang.java.programmer
Date: Sun, 08 May 2011 14:00:09 +1200
Organization: Geek Central
Lines: 6
Message-ID: <iq4tf9$ccn$1@lust.ihug.co.nz>
References: <tnibs6hnfdp2cav0u74d8heeqsdkvg1c6a@4ax.com>
NNTP-Posting-Host: 118-92-95-178.dsl.dyn.ihug.co.nz
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
X-Trace: lust.ihug.co.nz 1304820009 12695 118.92.95.178 (8 May 2011 02:00:09 GMT)
X-Complaints-To: abuse@ihug.co.nz
NNTP-Posting-Date: Sun, 8 May 2011 02:00:09 +0000 (UTC)
User-Agent: KNode/4.4.7
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:3775

In message <tnibs6hnfdp2cav0u74d8heeqsdkvg1c6a@4ax.com>,  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.