一道sql面试题

 

SELECT ISNULL(tt1.name,tt3.name) AS name,tt1.接通,tt3.未接通 FROM (
SELECT name,COUNT(name) '接通' FROM (
SELECT * FROM test WHERE result='接通') t1
GROUP BY name)tt1
FULL JOIN
(
SELECT * FROM (
SELECT name,COUNT(name) '未接通' FROM (
SELECT * FROM test WHERE result='未接通') t2
GROUP BY name) tt2) tt3

ON tt1.NAME=tt3.NAME

 

写的有点麻烦，暂时没想出更好的方法

posted @ 2017-11-16 17:50  chang1234  阅读(175)  评论(1)  编辑  收藏  举报