练习——使用排序查询学生相关信息 SELECT StudentNo as 学生编号,SubjectId AS 课程ID,StudentResult AS 成绩 FROM Result WHERE StudentResult>60 ORDER BY StudentResult,SubjectId /*按照出生日期查询第一个学期的学生信息*/ SELECT * FROM dbo.