22,209
社区成员
发帖
与我相关
我的任务
分享
select sum(case 很好 when 1 then 1 else 0 end) as sum_很好,
sum(case 较好 when 1 then 1 else 0 end) as sum_较好,
sum(case 一般 when 1 then 1 else 0 end) as sum_一般,
sum(case 接车 when 1 then 1 else 0 end) as sum_接车,
sum(case 机电 when 1 then 1 else 0 end) as sum_机电,
sum(case 钣金 when 1 then 1 else 0 end) as sum_钣金,
sum(case 美容 when 1 then 1 else 0 end) as sum_美容,
sum(case 销售 when 1 then 1 else 0 end) as sum_销售 from table
SELECT 'sum_很好' 评价类型 ,
SUM(CASE 很好
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_较好' 评价类型 ,
SUM(CASE 较好
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_一般' 评价类型 ,
SUM(CASE 一般
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_接车' 评价类型 ,
SUM(CASE 接车
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_机电' 评价类型 ,
SUM(CASE 机电
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_钣金' 评价类型 ,
SUM(CASE 钣金
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_美容' 评价类型 ,
SUM(CASE 美容
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
UNION ALL
SELECT 'sum_销售' 评价类型 ,
SUM(CASE 销售
WHEN 1 THEN 1
ELSE 0
END) 得分
FROM [table]
SELECT 'sum_很好',sum(case 很好 when 1 then 1 else 0 end) FROM table
UNION ALL
SELECT 'sum_较好',sum(case 较好 when 1 then 1 else 0 end) FROM table
以此类推
select c '评价类型',x '得分'
from (select
sum(case 很好 when 1 then 1 else 0 end) as sum_很好,
sum(case 较好 when 1 then 1 else 0 end) as sum_较好,
sum(case 一般 when 1 then 1 else 0 end) as sum_一般,
sum(case 接车 when 1 then 1 else 0 end) as sum_接车,
sum(case 机电 when 1 then 1 else 0 end) as sum_机电,
sum(case 钣金 when 1 then 1 else 0 end) as sum_钣金,
sum(case 美容 when 1 then 1 else 0 end) as sum_美容,
sum(case 销售 when 1 then 1 else 0 end) as sum_销售
from [table]) a
unpivot
(x for c in([sum_很好],[sum_较好],[sum_一般],[sum_接车],[sum_机电],[sum_钣金],[sum_美容],[sum_销售])) p