--准备数据
create table course (stname varchar(10), math int, english int); insert into course values('Jame', 65, 97); insert into course values('Tom',88,59); insert into course values('calvin',98,99); select * from course;
--pivot是工具表，列转行一定会用到 create table pivot (id int); insert into pivot values (1); insert into pivot values (2); select * from pivot; select stname, case id
when 1 then 'Math' when 2 then 'English' else '0'
end as subject, case id
when 1 then math when 2 then english else 0
end as grade from course,pivot
因篇幅问题不能全部显示，请点此查看更多更全内容
Copyright © 2019- igat.cn 版权所有 赣ICP备2024042791号-1
违法及侵权请联系：TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务