举一反三
- 下列语句（）能够查询所有英语类课程的信息。 A: SELECT * FROM Course WHERE cname LIKE ‘%英语’ B: SELECT * FROM Course WHERE cname LIKE ‘%英语%’ C: SELECT * FROM Course WHERE cname LIKE ‘_英语_’ D: SELECT * FROM Course WHERE cname LIKE ‘*英语*’
- 以下（ ）SQL语句可以查询出课程名中只包含“_design”字符串的课程信息。 A: select * from course where cname like '%_design%' B: select * from course where cname like '%\_design%' escape '\' C: select * from course where cname like '% D: _design%' escape ' E: ' F: select * from course where cname like '%*_design%' escape '*'
- 以下______SQL语句可以查询出课程名中只包含“C_数据”字符串的课程信息。( ) A: SELECT * FROM cj_table WHERE CNAME LIKE '%C\_数据%'; B: SELECT * FROM cj_table WHERE CNAME LIKE '%C*_数据%' ESCAPE '*'; C: SELECT * FROM cj_table WHERE CNAME LIKE '%C D: _数据%' ESCAPE ' E: '; F: SELECT * FROM cj_table WHERE CNAME LIKE '%C?_数据%' ESCAPE '?';
- Hive中的谓词like用于匹配特定的子串,能从courses表中查询书名包含,包含“大数据”的课程信息的是:( ) A: select * from courses where Cname like '%大数据%' B: select * from courses where Cname like '%大%数%据%' C: select * from courses where Cname like '_大_数_据_' D: select * from courses where Cname like '_大数据_'
- 查询选修了'数据库基础'课程的同学的学号,和这些同学选修的全部课程号和分数.select sno,cno,gradefrom ______________________ A: sc where sno in (select sno from sc join course on sc.cno=course.cno where cname='数据库基础') B: sc join course on sc.cno=course.cno where cname='数据库基础' C: sc where sno in (select sno from course where cname='数据库基础') D: sc where cno in (select cno from course where cname='数据库基础')
内容
- 0
在MySQL中，要查找课程表Courses中课程名cname以“数据”开头（如数据结构、数据库系统等）的所有课程记录，下列SQL语句表示正确的是( )。 A: select * from Courses where cname like “数据”; B: select * from Courses where cname like“%数据”; C: select * from Courses where cnamr like “数据%”; D: select * from Courses where cnamr like “%数据%”;
- 1
同时选修了‘数据结构’和‘操作系统’2门课程的同学学号、姓名。select student.sno,sname from student,sc,coursewhere student.sno=sc.sno and course.cno=sc.cnoand _________________________________________________ A: cname='数据结构' and student.sno in(select sno from sc,course where sc.cno=course.cno and cname='操作系统') B: cname='操作系统' and student.sno in(select sno from sc,course where sc.cno=course.cno and cname='数据结构') C: cname='数据结构' and cname='操作系统' D: student.sno in(select sno from sc,course where sc.cno=course.cno and cname='操作系统'and cname='数据结构')
- 2
从课程表中查询课程名包括“数据库”三个字的课程信息,where条件如何写?( ) A: cname like ‘数据库’ B: cname = ‘数据库’ C: cname like ‘%数据库%’ D: cname = ‘%数据库%’
- 3
查询学生的学号，姓名，选修课程号和课程成绩 A: select sid,sname,cid,grade from student,sc where student.sid=sc.sid B: select * from student,sc where student.sid=sc.sid C: select sid,sname,cid,cname from student,course D: select sid,sname,cid,cname from student,sc
- 4
有三个表，学生表 Stu(Sno,Sname,Ssex,Sbirthday,Sdept)，字段分别表示学号，姓名，性别，出生日期，所在系，学号为主码；课程表Course(Cno,Cname)字段分别表示课程号，课程名，课程号为主码,成绩表SC(Sno, Cno,degree)，字段分别表示学号，课程号，成绩，(Sno,Cno)共同为主码，分别参考Stu,Course表的主码。查询课程号是”C01””C02””CO3”的课程名的语句是？ A: SELECT Cname FROM Course WHERE Cno =”C01”&&”CO2”&&”CO3” B: SELECT Cname FROM Course WHERE Cno IN ”C01”&&”CO2”&&”CO3” C: SELECT Cname FROM Course WHERE Cno IN (”C01”, ”CO2”, ”CO3”) D: SELECT Cname FROM Course WHERE Cno IN( ”C01” AND ”CO2”AND ”CO3”)