Oracle 5분 단위로 시간을 집계하여 최대값 구하기

5분 단위로 데이터 분류

SELECT 
    TRUNC(DATE_COLUMN, 'MI') + (5 - MOD(TO_NUMBER(TO_CHAR(DATE_COLUMN, 'MI')), 5)) / (24 * 60) AS rounded_up_date
FROM 
    YOUR_TABLE;

5분 단위로 최대값 구하기

SELECT 
    TRUNC(DATE_COLUMN, 'MI') + (5 - MOD(TO_NUMBER(TO_CHAR(DATE_COLUMN, 'MI')), 5)) / (24 * 60) AS rounded_up_date,
    MAX(VALUE_COLUMN) AS max_value
FROM 
    YOUR_TABLE
GROUP BY 
    TRUNC(DATE_COLUMN, 'MI') + (5 - MOD(TO_NUMBER(TO_CHAR(DATE_COLUMN, 'MI')), 5)) / (24 * 60) AS rounded_up_date
ORDER BY 
    rounded_up_date;