帕累托图的SQL数据实现

最新推荐文章于 2023-03-06 17:00:25 发布

mao_mu_mu

最新推荐文章于 2023-03-06 17:00:25 发布

阅读量1.8k

点赞数

分类专栏： oracle java

本文链接：https://blog.csdn.net/mao_mu_mu/article/details/68945799

版权

该博客详细介绍了如何在Oracle数据库中查询并获取用于帕累托图展示的数据，内容涵盖数据查询步骤及如何将结果传递给前端JS代码进行可视化展示。

摘要由CSDN通过智能技术生成

一、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,