select a.jd,count(b.chr_id) as qs
from
(select 1 as jd from dual
union select 2 from dual
union select 1 from dual
union select 4 from dual) a,
yw_tfsj_jbxx b
where
a.jd=to_char(b.Date_lrsj,'q')(+)
and
a.jd=3
group by
a.jd
from
(select 1 as jd from dual
union select 2 from dual
union select 1 from dual
union select 4 from dual) a,
yw_tfsj_jbxx b
where
a.jd=to_char(b.Date_lrsj,'q')(+)
and
a.jd=3
group by
a.jd
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货