首页 > 其他 > 详细

时间查询条件区间查询

时间:2017-06-06 17:28:51      阅读:240      评论:0      收藏:0      [点我收藏+]

SELECT COUNT(1)
  FROM (SELECT w.log_name,
               w.cust_party_id,
               w.creation_date,
               row_number() over(PARTITION BY w.cust_party_id ORDER BY w.creation_date DESC) rn
          FROM cop_work_log w
         WHERE w.project_no IS NULL
           AND w.or_line_id IS NULL) cwl,
       cop_customer_header_v h,
       cop_fae_customer_assign ass,
       cop_cop_my_attention atten
 WHERE 1 = 1
   AND cwl.rn(+) = 1
   AND cwl.cust_party_id(+) = h.cust_party_id
   AND h.cust_party_id = ass.cust_party_id(+)
   AND(cwl.creation_date >= to_date(l_date_f, ‘YYYY-MM-DD‘) or l_date_f is null)
   AND(cwl.creation_date <= to_date(l_date_t, ‘YYYY-MM-DD‘) or l_date_t is null)
   AND ass.assign_person_id = 4012
   AND h.cust_party_id = atten.object_id(+)
   AND atten.attend_type(+) = 0

时间查询条件区间查询

原文:http://www.cnblogs.com/albert-think/p/6952458.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!