注意:此页面搜索的是所有试题
题目内容
(河南财经政法大学-数据库基础与应用)
[单选题,10分] 查找 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*.
参考答案