4条回答 默认 最新
- save4me 2015-01-21 15:33关注
刚才CASE语句漏了END,补上
SELECT poster_code , post_date , SUM(CASE poster_type WHEN 1 THEN quantity ELSE 0 END) AS [匿名数量] , SUM(CASE poster_type WHEN 2 THEN quantity ELSE 0 END) AS [实名数量] FROM [表名] GROUP BY poster_code , post_date
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报