题目
第1题
A.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = '刘晨');
B.SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';
C.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");
D.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'王华'.SAGE;
第2题
A.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = '刘晨');
B.SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';
C.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");
D.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'王华'.SAGE;
第4题
A.select sname from student where sdept=’CS‘ except select sname from student where sage<=20
B.select sname from student where sdept=’CS‘ intersect select sname from student where sage>20
C.select sname from student where sdept=’CS‘ and sage>20
D.select sname from student where sdept=’CS‘ union select sname from student where sage>20
第5题
A.select sname from student where sdept=’CS‘ and sage>20
B.select sname from student where sdept=’CS‘ intersect select sname from student where sage>20
C.select sname from student where sdept=’CS‘ except select sname from student where sage<=20
D.select sname from student where sdept=’CS‘ union select sname from student where sage>20
第6题
A.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE BETWEEN 15 AND 19;
B.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 AND SAGE >= 15;
C.SELECT * FROM S WHERE SDEP = ‘CS’ OR SAGE BETWEEN 15 AND 19;
D.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 OR SAGE >= 15;
第7题
A.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE BETWEEN 15 AND 19;
B.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 AND SAGE >= 15;
C.SELECT * FROM S WHERE SDEP = ‘CS’ OR SAGE BETWEEN 15 AND 19;
D.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 OR SAGE >= 15;
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!