一些SQL

       select

        round(sort_right_num/decode(sort_totle_num,   0 ,   1   ,sort_totle_num),   5 ) sort_right_percent
    from 
            (select 
              sum( case when g.signSiteId is not null then 
                           1  
                        else
                           0  
                   end
                 ) sort_totle_num,
               sum(
                    case when g.dispSiteId=g.signSiteId or g.dispSiteId=g.settlementSiteId then 
                            1  
                         else
                            0  
                    end
                 )sort_right_num
            from 
            (select t.a_disp_site_id as dispSiteId,
                    t.sign_site_id  as  signSiteId,
                    s.settlement_site_id as settlementSiteId
                  from 
                  ge_lu_ebill_analysis t inner join ass_site s on t.sign_site_id = s.id where t.sign_site_id is not null )g)

查询带时间的：

SELECT t.* FROM ge_lu_ebill_analysis t WHERE t.analysis_time >= to_timestamp('09/11/2013 00:00:00.000',
'mm/dd/yyyy hh24:mi:ss.ff3') and t.analysis_time<=to_timestamp('09/13/2013 00:00:00.000', 'mm/dd/yyyy
hh24:mi:ss.ff3')+1 

拿11到13号杭州市 江干区的数据去跑  这些数据在analysis表中应该都是有签收信息的  在用SQL测试

  select count ( 0   ) from ass_req_log      这个是记录的总条数  
  select sum(   0  ) from ass_req_log        这个是0