SQL语句“SELECT
* FROM emp WHERE ename LIKE 'A_'”能够查询字母A开头的所有雇员信息。()
* FROM emp WHERE ename LIKE 'A_'”能够查询字母A开头的所有雇员信息。()
举一反三
- SQL语句“SELECT<br/>* FROM emp WHERE ename LIKE 'A_'”能够查询字母<br/>A<br/>开头的所有雇员信息。()
- 要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为 A: SELECT * FROM Movie WHERE director LIKE ‘_a_’; B: SELECT * FROM Movie WHERE director LIKE ‘%a%’; C: SELECT * FROM Movie WHERE director LIKE ‘%a_’; D: SELECT * FROM Movie WHERE director LIKE ‘_a%’;
- 设ABC表的A列存储电话号码信息，查询不是以7开头的所有电话号码的查询语句是（ ）。 A: SELECT A FROM ABC WHERE A IS NOT ‘%7’ B: SELECT A FROM ABC WHERE A LIKE ‘%7%’ C: SELECT A FROM ABC WHERE A NOT LIKE ‘7%’ D: SELECT A FROM ABC WHERE A LIKE ‘[1-6]%’
- 下列语句（）能够查询所有英语类课程的信息。 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语句是(<br/>)。 A: SELECT<br/>* FROM students WHERE s_name='王' B: SELECT<br/>* FROM students WHERE s_name='王%' C: SELECT<br/>* FROM students WHERE s_name LIKE '王' D: SELECT<br/>* FROM students WHERE s_name LIKE '王%'