引用 2 楼 hebeishimeng 的回复:SQL code?1234567select 问卷Id, 'A' as '题目分类', avg (case when case when 题目分类 = 'A' then 得分 end) as '均分', 'B' as '题目分类', avg (case when case when 题目分类 = 'B' then 得分 en……
果断用decode
SQL code?1234567select 问卷Id, 'A' as '题目分类', avg (case when case when 题目分类 = 'A' then 得分 end) as '均分', 'B' as '题目分类', avg (case when case when 题目分类 = 'B' then 得分 end) as '均分'from 问卷结果表grou……
select 问卷Id, 'A' as '题目分类', avg (case when case when 题目分类 = 'A' then 得分 end) as '均分', 'B' as '题目分类', avg (case when case when 题目分类 = 'B' then 得分 end) as '均分' from 问卷结果表 group by 问卷Id
17,082
社区成员
55,236
社区内容
加载中
试试用AI创作助手写篇文章吧