Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using UNION ALL with GROUP BY
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