Re: GROUP BY clause

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Mon, 10 Sep 2007 15:44:19 +0200
Message-ID: <fc3h3b$1l45$1@sxnews1.qg.com>

fitzjarrell_at_cox.net wrote:

> On Sep 9, 12:36 pm, Jan Krueger <j..._at_stud.uni-hannover.de> wrote:

>> brenda.belt..._at_gmail.com wrote:
>>> Hi everybody,
>>> I just got to this area, so hope someone can help me with the
>>> following issue, I will really appreciate it.
>>> I want to query a column that is not part of the GROUP BY clause:
>>> SELECT c.country_id,
>>> r.region_id,
>>> r.manag_id,
>>> SUM(r.sls),
>>> SUM(r.cst)
>>> FROM country c INNER JOIN region r ON c.country_key = r.country_key
>>> GROUP BY c.country_id,
>>> r.region_id;
>>> Obviously, it's complaining because r.manag_id is not in the GROUP
>>> BY clause, but I need the result set to be as defined in the column
>>> clause. I wonder if there is any way to have these same columns in my
>>> query keeping my GROUP BY clause as it is now.
>> Hi Brenda,
>>

If adding manag_id to to group clause changes, with what logic you take manag_id? if it is indifferent you can use max(r.manag_id). Otherwise if it is more complex you can use analytic functions

regards

-- 
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

Received on Mon Sep 10 2007 - 08:44:19 CDT