WITH t AS
(
SELECT '홍길동' name, 'a' dept, 120 minute FROM dual
UNION ALL SELECT '이순신', 'a', 151 FROM dual
UNION ALL SELECT '김유신', 'b', 60 FROM dual
UNION ALL SELECT '안중근', 'c', 65 FROM dual
)
SELECT dept
, TO_CHAR(TO_DATE(SUM(minute)*60, 'sssss'), 'hh24:mi') time
FROM t
GROUP BY dept
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.