摘要:select * from student order by id drop table student select * from oracletest create table student( idcard varchar2(18), name varchar2(20), sex int, h
阅读全文
摘要:select * from ( selectclass 班级,subject,avg(grade) avg_gradefrom student_score group by class,subject) pivot (sum(avg_grade) for subject in ('语文', '数学'
阅读全文