A.Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
B.Select S# From SC Where C# = ‘001’ AND C#=‘002’;
C.Select S2.S# From SC S1, SC S2 Where S1.S# = S2.S# or S1.C#=‘001’ and S2.C#=‘002 ;
D.Select S1.S# From SC S1 Where S1. C# = ‘001’ AND S1.C#=‘002’;
第1题
A、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
B、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S2.Score > S1.Score;
C、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
D、Select * From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
第2题
A、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
B、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S2.Score > S1.Score;
C、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
D、Select * From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
第3题
A、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S2.Score > S1.Score;
B、Select * From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
C、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002’ and S1.Score > S2.Score;
D、Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
第4题
第5题
关系如上图所示,查询既学习课程号为001课程又学习课程号为002号课程的学生的学号,正确的是_______。
A、
B、
C、
D、
第6题
关系如上图所示,查询既学习课程号为001课程又学习课程号为002号课程的学生的学号,正确的是_______。
A、
B、
C、
D、
第7题
A、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
B、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 课号=‘2002’
C、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (FROM 选课 WHERE 课号=‘2002’ )
D、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
第8题
A、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
B、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 课号=‘2002’
C、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (FROM 选课 WHERE 课号=‘2002’ )
D、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
第9题
A、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 课号=‘2002’
B、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (FROM 选课 WHERE 课号=‘2002’ )
C、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
D、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
第10题
A、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 课号=‘2002’
B、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (FROM 选课 WHERE 课号=‘2002’ )
C、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
D、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!