<pre name="code" class="sql">select t2.fullname,count(1) from kefu3.t_pbh_problemprocesshis t ,T_XTT t2 where t.srtypeid=t2.id
and t.accepttime>=to_Date('20160901','yyyymmdd')
and t.accepttime<to_Date('20161001','yyyymmdd')
group by t2.fullname
select t2.fullname ,count(1)from kefu3.t_pbh_problemprocesshis t,t_xtt t2 where t.srtypeid=t2.id
and t.accepttime>=to_Date('20160901','yyyymmdd')
and t.accepttime<to_Date('20161001','yyyymmdd')
group by t2.fullname
<pre name="code" class="sql">select t2.fullnam
阅读背景：
关于oracle报invalid character问题
来源：互联网
分享到：
