摘要： with a as (select 日期,学号,名字, '语文' as 科目,语文 as 分数from tscounion allselect 日期,学号,名字, '数学' as 科目,数学 as 分数from tscounion allselect 日期,学号,名字, '英语' as 科目,英语... 阅读全文