以下______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 '?';
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 '?';
举一反三
- 以下（ ）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 '*'
- 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 '_大数据_'
- 下列语句（）能够查询所有英语类课程的信息。 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 ‘*英语*’
- 在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 “%数据%”;
- 下面哪条语句可以查询姓“张”并且年龄等于20岁的用户，请问用哪条语句？ A: Select * From table Where name like "%张%" And intAge=20 B: Select * From table Where name like "张%" And intAge=20 C: Select * From table Where name like "张%" And intAge="20" D: Select * From table Where name="张" And intAge=20