按日期分组间隔Oracle

SELECT TRUNC(date_column, 'DD') AS day, COUNT(*) AS count
FROM table_name
GROUP BY TRUNC(date_column, 'DD')
ORDER BY TRUNC(date_column, 'DD');

SELECT TRUNC(date_column, 'IW') AS week, COUNT(*) AS count
FROM table_name
GROUP BY TRUNC(date_column, 'IW')
ORDER BY TRUNC(date_column, 'IW');

SELECT TRUNC(date_column, 'MM') AS month, COUNT(*) AS count
FROM table_name
GROUP BY TRUNC(date_column, 'MM')
ORDER BY TRUNC(date_column, 'MM');

SELECT TRUNC(date_column, 'Q') AS quarter, COUNT(*) AS count
FROM table_name
GROUP BY TRUNC(date_column, 'Q')
ORDER BY TRUNC(date_column, 'Q');

SELECT TRUNC(date_column, 'YYYY') AS year, COUNT(*) AS count
FROM table_name
GROUP BY TRUNC(date_column, 'YYYY')
ORDER BY TRUNC(date_column, 'YYYY');