SqlServer面试题

某公司面试题

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'