17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT 问题号,
SUM (DECODE (答案, 'a', 1, 0)) "答案1选择人数",
SUM (DECODE (答案, 'b', 1, 0)) "答案2选择人数",
SUM (DECODE (答案, 'c', 1, 0)) "答案3选择人数",
SUM (DECODE (答案, 'd', 1, 0)) "答案4选择人数"
FROM table1
group by 问题号
max+
case when