Mysql子查询
问题描述:
我有2个查询即时尝试运行在一起。我似乎可以得到它的工作。他们每个查询工作自交。但一旦我尝试使其与子查询一起加入我似乎无法得到工作Mysql子查询
SELECT T1,100 * SUM(IF(C1='UNKNOWN', 0, 1))/COUNT(C1) as 'MATCHING' FROM t1.CSLog WHERE CSHOUSE LIKE 'N%' group by CSHOUSE
SELECT T1,100 * SUM(IF(C1='UNKNOWN', 1, 0))/COUNT(C1) as 'NOTMATCHING' FROM t1.CSLog WHERE CSHOUSE LIKE 'N%' group by CSHOUSE
输出应该是这样的
t1 | MATCHING | NOTMATCHING
2 | 100% | 0.0%
3 | 0.0 | 100%
答
这个怎么样选择?
SELECT
T1,
100 * SUM(IF(C1='UNKNOWN', 0, 1))/COUNT(C1) as 'MATCHING',
100 * SUM(IF(C1='UNKNOWN', 1, 0))/COUNT(C1) as 'NOTMATCHING'
FROM t1.CSLog
WHERE CSHOUSE LIKE 'N%'
group by CSHOUSE
输出没有再次输入:-( – Strawberry