要找出所有名字第二个字母为“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%’;
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%’;
举一反三
- 下列语句（）能够查询所有英语类课程的信息。 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语句“SELECT<br/>* FROM emp WHERE ename LIKE 'A_'”能够查询字母A开头的所有雇员信息。()
- 查询姓“李”的学生的所有信息 A: select * from student where sname like ‘#李%’ B: select * from student where sname like ‘%李#’ C: select * from student where sname like “%李%” D: select * from student where sname like ‘%李%
- 【单选题】若要“检索名字为张某某的所有同学姓名”,SQL语句正确的是()。 A. SELECT Sname FROM Student WHERE Sname Like ‘张____’ B. SELECT Sname FROM Student WHERE Sname Like ‘张%’ C. SELECT Sname FROM Student WHERE Sname Like ‘张_’ D. SELECT Sname FROM Student WHERE Sname Not Like ‘张_ _’
- 从Student表检索姓周的学生，对应的SQL语句是( )。 A: Select * From Student Where Sname like '周%' B: Select * From Student Where Sname like '%周' C: Select * From Student Where Sname like '_周' D: Select * From Student Where Sname like '周_'