sql行转列查询

最新推荐文章于 2022-09-03 14:25:37 发布

weixin_30770495

最新推荐文章于 2022-09-03 14:25:37 发布

阅读量70

点赞数

原文链接：http://www.cnblogs.com/whlhaikuotiankong/archive/2012/04/18/2455255.html

版权

SELECT
            recordtime,
            NewCollect=ISNULL(SUM(CASE Type2 WHEN 1 THEN newcnt END),0),
            CancelCollect=ISNULL(SUM(CASE Type2 WHEN 1 THEN cancelcnt END),0),
            NewKeyword=ISNULL(SUM(CASE Type2 WHEN 2 THEN newcnt end),0),
            CancelKeyword=ISNULL(SUM(CASE Type2 WHEN 2 THEN cancelcnt END),0),
            NewBlink=ISNULL(SUM(CASE Type2 WHEN 3 THEN newcnt end),0),
            CancelBlink=ISNULL(SUM(CASE Type2 WHEN 3 THEN cancelcnt END),0)
FROM B_Com

WHERE 1=1 {0}

GROUP BY recordtime

ORDER BY recordtime DESC

转载于:https://www.cnblogs.com/whlhaikuotiankong/archive/2012/04/18/2455255.html