Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using UNION ALL with GROUP BY

Re: Using UNION ALL with GROUP BY

From: <mpacheco_brazil_at_hotmail.com>
Date: 23 Feb 2006 10:29:34 -0800
Message-ID: <1140719374.731311.195280@i40g2000cwc.googlegroups.com>


Yes it is possible since Oracle 8i (not sure that exact version). Just put the UNION statement as a sub-select in the FROM clause and then group. You cannot group by column number also, you need to specify the column name or expression.

SELECT

Received on Thu Feb 23 2006 - 12:29:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US