WITH T ( ID , DT , TM ) AS ( SELECT '20370' , '20190829' , '0830' FROM DUAL UNION ALL SELECT '20370' , '20190829' , '1200' FROM DUAL UNION ALL SELECT '20338' , '20190829' , '0830' FROM DUAL UNION ALL SELECT '20338' , '20190829' , '1200' FROM DUAL ) SELECT ID , DT , MIN(TM) "시작시간" , MAX(TM) "종료시간" FROM T GROUP BY ID , DT