SQL 查询语句错误修正 - 统计不同平台 App 数量
这段代码存在语法错误。在第一个子查询的末尾缺少闭合括号""").修正后的代码如下:\n\nSELECT SUM(cnt) AS total_count, Ds \nFROM (\n SELECT COUNT(DISTINCT AppIdentifier) AS cnt, Ds \n FROM log_iMonkey_iOS_overview \n GROUP BY Ds \n UNION ALL \n SELECT COUNT(DISTINCT AppIdentifier) AS cnt, Ds \n FROM log_iMonkey_Android_overview \n WHERE PlatformType != 0 AND AppIdentifier != 'identifier' \n GROUP BY Ds \n UNION ALL \n SELECT COUNT(DISTINCT PlatformType) AS cnt, Ds \n FROM log_iMonkey_Wechat_overview \n WHERE PlatformType != 0 \n GROUP BY Ds \n) AS subquery \nGROUP BY Ds
原文地址: https://www.cveoy.top/t/topic/pQ0U 著作权归作者所有。请勿转载和采集!