sql先分组，再算百分比

最新推荐文章于 2022-12-22 14:29:38 发布

.NET跨平台

最新推荐文章于 2022-12-22 14:29:38 发布

阅读量1.2k

点赞数

分类专栏： SqlServer数据库文章标签： sql 数据库 sqlserver

原文链接：https://blog.csdn.net/WuLex

版权

SqlServer数据库专栏收录该内容

179 篇文章 32 订阅

订阅专栏

--先分组，再算百分比

SELECT a.cooperationintention,
       a.organizationid,
       Count(*)                                                  数量,
       CONVERT (DECIMAL(18, 2), Cast(Count(*) AS FLOAT) /
                                Cast(
                                                         (
                                SELECT Count(*)
                                      FROM   sg_discuss b
                                      WHERE  a.organizationid
                                             = b.organizationid
                                             AND serverlicenseid =
                                '61DD8BE1-9458-41FB-AA56-DA11634E11CD') AS
                                                         FLOAT)) 占比
FROM   sg_discuss a
WHERE  serverlicenseid = '61DD8BE1-9458-41FB-AA56-DA11634E11CD'
GROUP  BY a.cooperationintention,
          a.organizationid

SELECT a.cooperationintention,
       a.organizationid,
       Count(*)                                             数量,
       CONVERT (DECIMAL(18, 2), Cast(Count(*) AS FLOAT) / Cast(
                                (SELECT Count(*)
                                 FROM   sg_discuss b
                                 WHERE  a.organizationid
                                        = b.organizationid
                                        AND serverlicenseid =
                                '61DD8BE1-9458-41FB-AA56-DA11634E11CD'
                                                                       AND
                                        discussdate > CONVERT(DATETIME,
                                                      '2018-09-01', 20)
                                                                       AND
                                        cooperationintention IN ( '10%',
                                        '20%' )) AS FLOAT)) 占比
FROM   sg_discuss a
WHERE  serverlicenseid = '61DD8BE1-9458-41FB-AA56-DA11634E11CD'
       AND discussdate > CONVERT(DATETIME, '2018-09-01', 20)
       AND cooperationintention IN ( '10%', '20%' )
GROUP  BY a.cooperationintention,
          a.organizationid