2019-04-10上午.Net面试题

1.

2.

web

--请写一段sql server脚本实现功能：a.依据Scores和users表。找出每一个科目成绩最高的学生（成绩并列第一的学生，须要都列出来）

select SC.Course,US.Name,T.最高分 from Scores as SC join (select R.Course,MAX(R.Score) as 最高分 from (select u.Name,s.Score,s.Course from Scores as s join Users as u on s.UserId=u.ID) as R group by R.Course) as T on SC.Score=T.最高分 join Users AS US on SC.UserId=US.ID order by T.最高分

--b.依据学生成绩表(Scores)，找出总分最高的那个学生，结果以下图所示： 
select top 1 * from (select M.Name,S.UserId,M.total from Users as U join (select sum(S.Score)as total,U.Name from Scores as S join Users as U on S.UserId=U.ID group by U.Name) as M on U.Name=M.Name join Scores as S on S.UserId=U.ID) as G order by G.total desc

3.

4.

5.

6.

7.

8.

9.

10.
sql