有关系表SC(S# , C#, Score),求“001”号课成绩比“002”号课成绩高的所有学生的学号。下列SQL语句正确的是_________。[br][/br](单选题)
A: Select S1.S
B: From SC S1, SC S2 Where S1.S
C: = S2.S
D: and S1.C
E: =‘001’ and S2.C
F: =‘002 ;
G: Select S1.S
H: From SC S1, SC S2 Where S1.S
I: = S2.S
J: and S1.C
K: =‘001’ and S2.C
L: =‘002’ and S1.Score > S2.Score;
M: Select S1.S
N: From SC S1, SC S2 Where S1.S
O: = S2.S
P: and S1.C
Q: =‘001’ and S2.C
R: =‘002’ and S2.Score > S1.Score;
S: Select * From SC S1, SC S2 Where S1.S
T: = S2.S
U: and S1.C
V: =‘001’ and S2.C
W: =‘002’ and S1.Score > S2.Score;
A: Select S1.S
B: From SC S1, SC S2 Where S1.S
C: = S2.S
D: and S1.C
E: =‘001’ and S2.C
F: =‘002 ;
G: Select S1.S
H: From SC S1, SC S2 Where S1.S
I: = S2.S
J: and S1.C
K: =‘001’ and S2.C
L: =‘002’ and S1.Score > S2.Score;
M: Select S1.S
N: From SC S1, SC S2 Where S1.S
O: = S2.S
P: and S1.C
Q: =‘001’ and S2.C
R: =‘002’ and S2.Score > S1.Score;
S: Select * From SC S1, SC S2 Where S1.S
T: = S2.S
U: and S1.C
V: =‘001’ and S2.C
W: =‘002’ and S1.Score > S2.Score;
举一反三
- 设学生表S、课程表C和学生选课表SC的结构如下； S(学号，姓名，年龄，系别) C(课程号，课程名) SC(学号，课程号，成绩) 查询学生姓名及所选修课程的课程号和成绩，实现此功能的SELECT语句是 ______。 A: SELECT 姓名，S课程号，S成绩FROM S WHERE学号＝S学号 B: SELECT 姓名，S课程号，S成绩FROM SC WHERE学号＝S成绩 C: SELECT 姓名，S课程号，S成绩FROM S，SC WHERE 学号＝S学号 D: SELECT 姓名，S课程号，S成绩FROM S，SC
- 下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: SELECT S D: FROM SC GROUP BY S E: HAVING COUNT(*)>3 F: SELECT S G: ,Cname FROM SC GROUP BY S H: WHERE COUNT(*)>3 I: SELECT S J: FROM SC WHERE COUNT(*)>3 GROUP BY S
- 电子组态1s2p所构成的原子态为（ ）。 A: 1s2p1S0，1s2p1P1, 1s2p3S1 1s2p3P2,1,0 B: 1s2p1S0，1s2p1P1 C: 1s2p1S0，1s2p3S1 D: 1s2p1P1，1s2p3P2,1,0
- 试判断原子态：1s1s3S1,1s2p3P2,1s2p1D1,2s2p3P2中，下面哪组是存在的？ A: 1s1s3S1,1s2p3P2; B: 1s2p3P2,1s2p1D1; C: 1s2p3P2,2s2p3P2; D: 1s1s3S1,1s2p1D1;
- 查询选修了课程号为‘C2’的学生号和姓名,若用下列SQL的SELECT语句表达时, 是错误的? A: SELECT S.S B: ,SNAME FROM S WHERE S C: = (SELECT SS D: FROM SC WHERE C E: =‘C2’) F: SELECT S.S G: ,SNAME FROM S,SC WHERE S H: = SS I: AND C J: =‘C2’ K: SELECT S.S L: ,SNAME FROM S,SC WHERE S M: = SS N: AND C O: =‘C2' ORDER BY S P: Q: SELECT S.S R: ,SNAME FROM S WHERE S S: IN(SELECT SS T: FROM SC WHERE C U: =‘C2' )