在postgresql中使用定义的起始基准按季度间隔(或任何时间间隔)对数据进行分组

SELECT date_part('year', date_column) AS year,
       date_part('quarter', date_column) AS quarter,
       other_columns
FROM your_table;

SELECT CASE
         WHEN date_part('quarter', date_column) = 1 THEN 'Q1'
         WHEN date_part('quarter', date_column) = 2 THEN 'Q2'
         WHEN date_part('quarter', date_column) = 3 THEN 'Q3'
         WHEN date_part('quarter', date_column) = 4 THEN 'Q4'
       END AS quarter,
       COUNT(*) AS count
FROM your_table
GROUP BY quarter;

SELECT CASE
         WHEN date_part('quarter', date_column) = 1 AND date_part('month', date_column) BETWEEN 1 AND 3 THEN 'Q1'
         WHEN date_part('quarter', date_column) = 2 AND date_part('month', date_column) BETWEEN 4 AND 6 THEN 'Q2'
         WHEN date_part('quarter', date_column) = 3 AND date_part('month', date_column) BETWEEN 7 AND 9 THEN 'Q3'
         WHEN date_part('quarter', date_column) = 4 AND date_part('month', date_column) BETWEEN 10 AND 12 THEN 'Q4'
       END AS quarter,
       COUNT(*) AS count
FROM your_table
GROUP BY quarter;