select sum(ID) as quantity,
year(GMT_CREATED) as gyear, quarter(GMT_CREATED) as gquarter from TABLE1 as t1 where t1.STATUS='正常' group by gyear,gquarter本文共 205 字，大约阅读时间需要 1 分钟。
select sum(ID) as quantity,
year(GMT_CREATED) as gyear, quarter(GMT_CREATED) as gquarter from TABLE1 as t1 where t1.STATUS='正常' group by gyear,gquarter转载于:https://my.oschina.net/jingshishengxu/blog/806743