查找yuangong表中所有电话号码（列名：telephone）的第一位为8或6，第三位为0的电话号码（）
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
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 "篮球*\