上海开发网站,网站开发搭建,广告公司联系方式,天津个人网站备案查询在开发中往往要用到类似下面的二维统计#xff1a; abtype15465type25454在SQL中使用CASE WHEN 语句可以很轻松的实现#xff1a; SELECT SUM(CASE WHEN typetype1 THEN 1 ELSE 0 END) AS a
,SUM(CASE WHEN typetype2 THEN 1 ELSE 0 END) AS b
FROM Table1 转载于:https://ww…在开发中往往要用到类似下面的二维统计 abtype15465type25454在SQL中使用CASE WHEN 语句可以很轻松的实现 SELECT SUM(CASE WHEN typetype1 THEN 1 ELSE 0 END) AS a
,SUM(CASE WHEN typetype2 THEN 1 ELSE 0 END) AS b
FROM Table1 转载于:https://www.cnblogs.com/adzhouyang/p/3151930.html