帕累托图的SQL数据实现

一、oracle数据查询出需要展示的数据结果

  select rownum id,
       sum(t.cap_ratio) over (order by rownum rows between unbounded preceding and current row) sum_cap_ratio,  
       t.user_ratio
 from (select rownum id,
       cast(cap_ratio * 100 as number(8, 5)) cap_ratio,
       cast(user_ratio * 100 as number(8, 5)) user_ratio
  from (select cons_name,
               sum_cap,
               cap_ratio,
               rownum / count_cons_name user_ratio
          from (select cons_name,
                       sum_cap,
                       total,
                       sum_cap / total cap_ratio,
                       (select count(distinct cons_name) from t_cons_plt where org_no like '13401%' and  build_date <= to_date('2016-12-12','yyyy-mm-dd')
                           ) count_cons_name
                  from (select cons_name,sum(contract_cap) sum_cap,