56,677
社区成员
发帖
与我相关
我的任务
分享
select count(distinct t.pid),
count(t.pid),
sum(concat(t.curr_dose, '')),
t.advi_date
from aidszh_mst_medicine t force index(IDX_ADVIDATE)
where 1 = 1
and t.clin_zonecode like '320103%'
and t.advi_date >= to_date('2010-06-09', 'yyyy-mm-dd')
and t.advi_date <= to_date('2010-07-09', 'yyyy-mm-dd')
and t.clin_no = '320103065'
group by t.advi_date