查找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*'
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的电话号码（） 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
- 查找yuangong表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码( )。
- 查询姓“李”的学生的所有信息 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 ‘%李%
- 从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 '周_'
- 对于学生信息表：student(sno，sname，sex，age，dept)，要查询所有刘姓学生的信息，正确的语句是 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'刘&'