1.创建查询学生最高成绩的视图 create view [dbo].[GetMaxGrade] as select Sno 学号, max(Grade) 成绩 from sc group by Sno 思路:先分组,再查询