查询条件是某个时间段

查询4月份的数据

select count(*)
  from hz_clfht.tpe_zrhtqd a, HZ_CYZT.TPP_CYQYXX b
where a.jjgscode = b.code
   and b.QYLB = 7002
   and a.bjsj < to_date('2014-05-01', 'yyyy-mm-dd')
   and a.bjsj>= ADD_MONTHS(to_date('2014-05-01','yyyy-mm-dd'), -1)
   and b.qymc='杭州华邦房地产代理有限公司'




  select count(*)
  from hz_clfht.tpe_zrhtqd a, HZ_CYZT.TPP_CYQYXX b
where a.jjgscode = b.code
   and b.QYLB = 7002
   and to_char(a.bjsj, 'yyyy-mm')='2014-04'
   and b.qymc='杭州华邦房地产代理有限公司'



  select count(*)
  from hz_clfht.tpe_zrhtqd a, HZ_CYZT.TPP_CYQYXX b
where a.jjgscode = b.code
   and b.QYLB = 7002
   and to_char(a.bjsj, 'yyyy')='2014'
  
and to_char(a.bjsj, 'mm')='04'

and b.qymc='杭州华邦房地产代理有限公司'


查询一季度则如下

select count(*)
  from hz_clfht.tpe_zrhtqd a, HZ_CYZT.TPP_CYQYXX b
where a.jjgscode = b.code
   and b.QYLB = 7002
   and a.bjsj < to_date('2014-05-01', 'yyyy-mm-dd')
   and a.bjsj>= ADD_MONTHS(to_date('2014-05-01','yyyy-mm-dd'), -3)
   and b.qymc='杭州华邦房地产代理有限公司'