what do you get with:
select b.*
from
(select /*+ FULL(a) PARALLEL(a, 8) */
transcode, filename, rectype, count(*) cnt, sum(charge) sum_c, sum(units) sum_u
from recs a
group by transcode, filename, rectype) b
where b.filename like 'XY%'
|
Results 1 to 10 of 11
Threaded View
|
Click Here to Expand Forum to Full Width |