17,377
社区成员
发帖
与我相关
我的任务
分享
select id,substr(jysj,1,10),count(*) as jyrq from yw_jfgl_cxjylsb_ls where id='63000099'
and (((substr(jysj,1,10)>='2017-03-04') and (substr(jysj,1,10)<='2017-03-05'))
or ((substr(jysj,1,10)>='2017-03-11') and (substr(jysj,1,10)<='2017-03-12'))
or ((substr(jysj,1,10)>='2017-03-18') and (substr(jysj,1,10)<='2017-03-19'))
or ((substr(jysj,1,10)>='2017-03-25') and (substr(jysj,1,10)<='2017-03-26'))
or ((substr(jysj,1,10)>='2017-04-01') and (substr(jysj,1,10)<='2017-04-02'))
or ((substr(jysj,1,10)>='2017-04-08') and (substr(jysj,1,10)<='2017-04-09')))
and (ZHKHYBT is not null)
group by jgh,substr(jysj,1,10) order by jyrq;