摘要:
CREATE TABLE [dbo].[student_score]( [username] [nvarchar](20) NULL, [kemu] [nvarchar](20) NULL, [score] [int] NULL) ON [PRIMARY]1.sql中行列转置2.语句 select username, sum(case when kemu = '数学' then score else 0 end) as '数学', sum(case when kemu = '英语' then score else 0 end )as '英 阅读全文