有关系表SC ( Sno , Cno, Score)，求既学过“001”号课又学过 “002”号课的所有学生的学号，下列SQL语句正确的是?
A. Select Sno From SC Where Cno = ‘001’ AND Cno=‘002’;
B. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ ;
C. Select S2.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno or S1.Cno=‘001’ and S2.Cno=‘002’ ;
D. Select S1.Sno From SC S1 Where S1. Cno = ‘001’ AND S1.Cno=‘002’;
查看答案
有关系表SC(Sno , Cno, Score)，求“001”号课成绩比“002”号课成绩高的所有学生的学号。下列SQL语句正确的是?
A. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S2.Score > S1.Score;
B. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002 ;
C. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S1.Score > S2.Score;
D. Select * From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S1.Score > S2.Score;
已知如下关系：学生Student(Sno, Sname)，课程Course(Cno, Cname, Tno)，选课SC(Sno, Cno, Score)，教师T(Tno, Tname)。其中Sno为学号，Sname为学生命名，Cno为课号，Cname为课程名，Tno为教师编号，Score为成绩，Tname为教师名。阅读SQL语句:SELECT Sname FROM Student, SC, Course WHERE Student.Sno=SC.Sno ANDCourse.Cno=SC.Cno AND Tno= ‘T01’ AND Score<60；关于其查询结果，下列说法正确的是？
A. 课程不及格的所有学生的姓名
B. 学习非T01号教师讲授课程不及格的所有学生的姓名
C. 学习T01号教师讲授课程及格的所有学生的姓名
D. 学习T01号教师讲授课程不及格的所有学生的姓名
已知S(Sno,SN,AGE,SEX),Sno学号，SN姓名。若要检索所有比'王华'年龄大的学生姓名、年龄和性别，正确的SELECT语句是_________。
A. SELECT SN,AGE,SEX FROM S WHERE AGE > 王华.AGE
B. SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C. SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN='王华')
D. SELECT SN, AGE, SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN='王华')
下面有关HAVING子句，说法不正确的是_________。
A. 使用HAVING子句的作用是过滤掉不满足条件的分组
B. 使用HAVING子句的同时不能使用WHERE子句
C. 使用HAVING子句的同时可以使用WHERE子句
D. HAVING子句必须与GROUP BY 子句同时使用，不能单独使用
微信支付 
支付宝支付