oracle 数据库:
SELECT
to_char(t.PRODUCTIONDATE,'yyyy-MM-dd') AS 生产日期,
count(*) 统计
FROM
FR_Sfx_Ycl_ProductionRecords t
group by to_char(t.PRODUCTIONDATE,'yyyy-MM-dd')
having count(*) >110
and count(*)<158;
SELECT
to_char(t.PRODUCTIONDATE,'yyyy-MM-dd') AS 生产日期,
count(*) 统计
FROM
FR_Sfx_Ycl_ProductionRecords t
group by to_char(t.PRODUCTIONDATE,'yyyy-MM-dd')
${if(len(num1)==0,""," having count(*) >='"+num1+"'")}
${if(len(num2)==0,""," and count(*) <='"+num2+"'")}
结果展示:
![1613809458411056.png image.png](/upload/wenda/20210220/1613809458411056.png)