Question

有1到12月的记录值,怎样用sql分组查出每季度的值

Answer 1

SELECT 字段 from tabel where date1 BETWEEN '2014-01-01 0:00:00' AND '2014-03-31 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-04-01 0:00:00' AND '2014-06-30 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-07-01 0:00:00' AND '2014-09-30 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-10-01 0:00:00' AND '2014-12-31 23:59:59'

Answer 2

select (月份 / 4)+1
这个出来的就是第几季度,group by 这个就可以了
至于月份怎么取,每个数据库日期函数都不一样, 自个儿转换下就ok了,没什么难度的