一些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