1~2초는 없는거낙요

with test as (

SELECT '2013-06-30' 날짜, '000' 시간 , '0.8148' 값 FROM DUAL UNION ALL

SELECT '2013-06-30', '001' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '002' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '003' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '004' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '005' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '010' , '0.80775' FROM DUAL UNION ALL

SELECT '2013-06-30', '011' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '012' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '013' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '014' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '015' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '020' , '0.803' FROM DUAL UNION ALL

SELECT '2013-06-30', '021' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '022' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '023' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '024' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '025' , '1' FROM DUAL UNION ALL

SELECT '2013-06-30', '030' , '0.8585' FROM DUAL

)

SELECT ceil ( rownum / 2 )

, MAX ( 날짜 )

, MIN ( 시간 )

, MAX ( 시간 )

FROM (

SELECT *

FROM test

ORDER BY 날짜

, 시간

)

GROUP BY ceil ( rownum / 2 )

ORDER BY 4

SELECT dt
     , MIN(tm) ||'~'|| MAX(tm) tm
     , AVG(v) v
  FROM t
 GROUP BY dt, FLOOR(tm / 2)
 ORDER BY dt, tm
;

 답변 감사드립니다.