SQL练习2

来源:互联网 发布:php实例化是什么意思 编辑:程序博客网 时间:2024/04/29 05:32
SELECT SubjectName as 科目  FROM SubjectWHERE GradeId=1SELECT StudentName as 学生姓名 ,住址=Address FROM Student WHERE GradeId=2 AND Sex='男'SELECT StudentName as 学生姓名, GradeId as 年级 FROM Student WHERE Email is NULLSELECT StudentName as 学生姓名 FROM Student WHERE GradeId=2 AND BornDate>'1990'SELECT StudentResult as 学生成绩 FROM ResultWHERE SubjectId=1 AND ExamDate='2013-12-22'

0 0
原创粉丝点击