某公司面试题
1.如图所示,正确
2.正确答案
select StudentId from Scores where score in(select max(score) as 最高成绩 from Scores group by CourseId)
3。正确答案
select studentId,
sum(case CourseId when 01 then score else 0 end) as 科目01,
sum(case CourseId when 02 then score else 0 end) as 科目02,
sum(case CourseId when 03 then score else 0 end) as 科目03
from Scores where studentId=0101
group by studentId
sqlserver 如何插入单引号
insert into test_pivot(name) values('li''ming')
select * from test_pivot where name='li''ming'