问题详情

查找 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*.

时间:2021-09-01 20:33 关键词: 联大 河南财经政法大学 数据库基础与应用

答案解析

C