sql中对某个字段进行占比计算

最新推荐文章于 2023-05-06 15:01:12 发布

北方的木

最新推荐文章于 2023-05-06 15:01:12 发布

阅读量7.5k

点赞数 2

分类专栏： Sqlserver 文章标签： sql

本文链接：https://blog.csdn.net/q1923408717/article/details/115348991

版权

Sqlserver 专栏收录该内容

45 篇文章 3 订阅

订阅专栏

SELECT  a.wy_type ,
        a.counts ,
        b.sums ,
        ROUND(CONVERT(DECIMAL(18, 2), a.counts) / b.sums * 100, 4) AS proportion
FROM    ( SELECT    wy_type ,
                    COUNT(h.house_id) AS counts
          FROM      p_building_house h
          WHERE     h.proj_id = 1
          GROUP BY  h.proj_id ,
                    wy_type
        ) AS a ,
        ( SELECT    COUNT(*) AS sums
          FROM      p_building_house
          WHERE     proj_id = 1
        ) AS b;