当前年季度查询个数
select
((MONTH( ss.createTime)-1) DIV 3) +1,count(*)
from s_securitygrades ss
where
date_format(ss.createTime,'%Y')=Year(CurDate())
group by YEAR( ss.createTime)*10+((MONTH( ss.createTime)-1) DIV 3) +1
上面这个用在mybatis里面找不到div需要改为如下
select
FLOOR( (MONTH( ss.createTime)-1) / 3)+1,count(*)
from s_securitygrades ss
WHERE
date_format(ss.createTime,'%Y')=Year(CurDate())
and ss.`companyId` = 139
group by
YEAR( ss.createTime)*10+FLOOR( (MONTH( ss.createTime)-1) / 3)+1
当前年月份查询个数
COUNT( * ) denggerNum,
date_format( shd.createTime, '%m' ) months
FROM
s_hidden_danger shd
where
date_format(shd.createTime,'%Y')=Year(CurDate())
GROUP BY
date_format( shd.createTime, '%m' )
ORDER BY
months