你是累计就是直接一个汇总数据?累计的话你想只展示一个值?
select * from 表名称
where 1=1
and 时间字段>='${if(ROUNDUP(DAY(TODAY())/10,0)=1&&cs="旬" ,FORMAT(today(),"yyyy-MM-01"),if(ROUNDUP(DAY(TODAY())/10,0)=2&&cs="旬",FORMAT(today(),"yyyy-MM-11"),if(ROUNDUP(DAY(TODAY())/10,0)>2&&cs="旬",FORMAT(today(),"yyyy-MM-21"),if(cs="月",FORMAT(DATEINMONTH(today(),1),"yyyy-MM-dd"),format("1990-01-01","yyyy-MM-dd")))))}'
and 时间字段<='${if(ROUNDUP(DAY(TODAY())/10,0)=1&&cs="旬" ,FORMAT(today(),"yyyy-MM-10"),if(ROUNDUP(DAY(TODAY())/10,0)=2&&cs="旬",FORMAT(today(),"yyyy-MM-20"),if(ROUNDUP(DAY(TODAY())/10,0)>2&&cs="旬",FORMAT(DATEINMONTH(today(),-1),"yyyy-MM-dd"),if(cs="月",FORMAT(DATEINMONTH(today(),-1),"yyyy-MM-dd"),format(today(),"yyyy-MM-dd")))))}'