var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Union Clause
I have to summarize the columns that are returned from a UNION ALL
in a cursor .
I tried to treat the resultant UNION ALL as a table and do the grouping but didn't work
Can anyone give me a hint ?
Something like this maybe:
with temp1 as (
select col1,col2 from mytable1
select col1,col2 from mytable2
) select count(*),sum(col1),avg(col2) from temp1