select a.no,a.cou,b.je_2 from
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060701') b
on a.no=b.no
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060701') b
on a.no=b.no
(select no,sum(je_1) cou
from table_1
group by no) a
left join
(select no,je_2 from table_1 where rq='20060301') b
on a.no=b.no
FROM(
select no,(je_1),max(rq||je_2) over(PARTITION by NO ) je_2
from table_1
) GROUP BY NO,substr(je_2,7)
from table_1
group by no
FROM (SELECT no, SUM (je_1) je
FROM table_1
GROUP BY no) a LEFT OUTER JOIN (SELECT no, SUM (je_2) je
FROM table_1
WHERE rq = '20060301'
GROUP BY no) b ON (a.no = b.no)
;