Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GROUP BY clause
brenda.beltran_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,
maybe I didn't get the point here, but I can't see the benefit of the
inline view suggestions.
If you just add the r.manag_id as a third column to your group by
clause, why is the resultset different from the one you expect?
Jan Received on Sun Sep 09 2007 - 12:36:13 CDT