题目
第1题
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
第2题
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
第3题
A.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNO = '20180601011');
B.SELECT SNAME, SAGE, SSEX FROM S WHERE SNO = '20180601011');
C.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNO = '20180601011');
D.SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'20180601011'.SAGE;
第4题
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;
第5题
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;
第6题
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;
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!