单选题:查找 student 表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码:
查找 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*'
答案:C
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*'
答案:C