河南成教 / 数据库应用1
正确率：100%
4、查找 student表中所有电话号码(列名：telephone)的第一位为8或6，第三位为0的电话号码
A. SELECT telephone FROM student WHERE telephone LIKE '[8,6]%0*'
B. SELECT telephone FROM student WHERE telephone LIKE '(8,6)*0%'
C. SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0%'
D. SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0*'
A. SELECT telephone FROM student WHERE telephone LIKE '[8,6]%0*'
B. SELECT telephone FROM student WHERE telephone LIKE '(8,6)*0%'
C. SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0%'
D. SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0*'
参考答案：
佳题速递：