with t(hour,c1,c2,v1,v2) as(
SELECT '2014-11-17 07','I003','1',   3000,107000 from dual union all
SELECT '2014-11-17 07','I003','1',  25000,107000 from dual union all
SELECT '2014-11-17 07','I003','2', 107000,107000 from dual union all
SELECT '2014-11-17 07','I003','7', 463000,107000 from dual union all
SELECT '2014-11-17 08','I003','7',1445000,137000 from dual union all
SELECT '2014-11-17 08','I003','3', 137000,137000 from dual union all
SELECT '2014-11-17 08','I003','1',   8000,137000 from dual union all
SELECT '2014-11-17 08','I003','1',  83000,137000 from dual union all
SELECT '2014-12-06 07','C152','1',2954000,284000 from dual union all
SELECT '2014-12-06 07','C152','1',  95000,284000 from dual union all
SELECT '2014-12-06 07','C152','5', 120000,284000 from dual union all
SELECT '2014-12-06 07','C152','1',   2000,284000 from dual union all
SELECT '2014-12-06 07','C152','4',  13000,284000 from dual union all
SELECT '2014-12-06 07','C152','1',  30000,284000 from dual union all
SELECT '2014-12-06 07','C152','1',  21000,284000 from dual union all
SELECT '2014-12-06 07','C152','2', 151000,284000 from dual union all
SELECT '2014-12-06 07','C152','7', 212000,284000 from dual
)
select max(rownum) no,hour,max(c1) c1
,decode(0,grouping_id(c1,c2,v1),max(c2),'A7') c2
,decode(0,grouping_id(c1,c2,v1),sum(v1),max(v2)) v1
from t
group by hour,grouping sets ((c1,c2,v1),())
order by no
 

뭐 이런식 이겠네요.

group by 안쓰고는

select rownum r, hour,c1,c2,v1 from t
union all
select null r, hour,c1,c2,v2 from( select row_number() over(partition by hour order by rownum desc) r,hour,c1, c2, v2 from t ) where r = 1
order by 2,1 nulls last
 

유니크한 정렬기준 항목이 보이질 않네요...
정렬기준이 없어 일단 Rownum 을 기준으로 하겠습니다.
정렬기준이 따로 있다면 rownum 대신 사용하시는게 좋겠네요.

SELECT hour, c1
     , MIN(c2) KEEP(DENSE_RANK LAST ORDER BY ROWNUM) c2
     , NVL(v1, v2) v
  FROM t
 GROUP BY hour, c1, v2, ROLLUP((ROWNUM, c2, v1))
 ORDER BY hour, c1, ROWNUM
;

SELECT hour, c1, c2
     , DECODE(lv, 1, v1, 2, v2) v
  FROM (SELECT hour, c1, c2, v1, v2
             , ROW_NUMBER() OVER(
               PARTITION BY hour, c1 ORDER BY ROWNUM DESC) rn
          FROM t
        )
     , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 2)
 WHERE lv <= DECODE(rn, 1, 2, 1)
 ORDER BY hour, c1, rn DESC, lv
;

 두분의 내공에 감탄을 금치 못합니다.

어떻게 sql 을 작성하느냐 인데 너무 감사합니다.

어떻게 형언할수 없는 이 감사함 

진심으로 감사드립니다.