SQL第九章数据查询基础上机题1-4

//查询学生相关基本信息
SELECT * FROM Student WHERE GradeId=1
 SELECT StudentName,Phone FROM Student  WHERE GradeId=2
 SELECT StudentName+Phone FROM Student  WHERE GradeId=2
 SELECT * FROM Student WHERE GradeId=1 AND Sex='女'
 SELECT SubjectName FROM Subject WHERE ClassHour>60




//查询学生相关复杂信息
SELECT SubjectName FROM Subject WHERE GradeId=1
SELECT StudentName,[Address] FROM Student WHERE GradeId=2 AND Sex='男'
SELECT StudentName,GradeId FROM Student WHERE Email IS NULL
SELECT StudentName FROM Student WHERE GradeId=2 AND BornDate>1990
SELECT StudentResult FROM Result WHERE ExamDate='2013-2-15' AND SubjectId=1


//使用排序查询学生相关信息

SELECT * FROM Student WHERE GradeId=1 ORDER BY BornDate
SELECT * FROM Result WHERE SubjectId=1 ORDER BY ExamDate,StudentResult DESC
SELECT TOP 5 StudentResult FROM Result WHERE SubjectId=8 AND ExamDate='2013-3-22' ORDER BY StudentResult DESC
SE