A: SELECT telephone FROM yuangong WHERE telephone LIKE’[8，6]%0*’
B: SELECT telephone FROM yuangong WHERE telephone LIKE’（8，6）*0%’
C: SELECT telephone FROM yuangong WHERE telephone LIKE’[86]_0%’
D: SELECT telephone FROM yuangong WHERE telephone LIKE’[86]_0*&rsquo
举一反三
- 查找student表中所有电话号码(列名：telephone)的第一位为8或6，第三位为0的电话号码（） A: SELECT telephone FROM student tWHERE telephone LIKE'[8,6]%0*' B: SELECT telephone FROM student WHERE telephone LIKE'(8,6)*0%' C: SELECTtelephoneFROMstudenttWHEREtelephoneLIKE'[8,6]_0%' D: SELECT telephone FROM student WHERE telephone LIKE'[8,6]_0*'
- 查找yuangong表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码( )。
- 设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]%’
- The write does not like telephone in a public telephone box, because ______. A: unventilated air B: it is far from his home C: it is not convenient D: he must pay for it
- 与SELECT TAB1.* FROM TAB1 WHERE InStr([简历]，"篮球")＜＞0功能相同的语句是( )。 A: A) SELECT TAB1.* FROM TAB1 WHERE TAB1.简历 Like "篮球" B: B) SELECT TAB1.* FROM TAB1 WHERE TAB1.简历 Like "*篮球" C: C) SELECT TAB1.* FROM TAB1 WHERE TAB1.简历 Like "*篮球*" D: D) SELECT TAB1.* FROM TAB1 WHERE TAB1.简历 Like "篮球*\
内容
- 0
查询学号(字符型，长度为8)尾字符是“0”的命令中，错误的是________。 A: SELECT * FROM 学生 WHERE “0”$学号 B: SELECT * FROM 学生 WHERE SUBSTR(学号，8)；“0” C: SELECT * FROM 学生 WHERE SUBSTR(学号，8，1)：“0” D: SELECT * FROM 学生 WHERE RIGHT(学号，8)：“0”
- 1
与SELECT TAB1.* FROM TAB1 WHERE InStr([简历],"篮球")＜＞0功能相同的语句是______。 A: SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "篮球" B: SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "*篮球" C: SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "*篮球*" D: SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "篮球*\
- 2
16. Where can you find the telephone number of a city council in a telephone book?
- 3
查询姓“李”的学生的所有信息 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 ‘%李%
- 4
要找出所有名字第二个字母为“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%’;