查找 student表中所有电话号码(列名：telephone)的第一位为8或6，第三位为0的电话号码 -题库考试答案搜索网

查找 student表中所有电话号码(列名：telephone)的第一位为8或6，第三位为0的电话号码

单选题

2021-09-01 20:33

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

查看答案

正确答案

试题解析

标签：联大河南财经政法大学数据库基础与应用

感兴趣题目

在STUDENT数据库的STUD表中任意查找一同学，有此人就显示该生的姓名、性别、出生日期等信息，无此人就显示“查无此人”。

查找authors表中的所有电话号码的首位为4，第二位为0或1的电话号码（）。

万方数据库使用布尔逻辑算符anD./or/not.其中A.anD.B表示（）。

口服补液及时纠正脱水，应用ORS，说法正确的是（）

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

Vessels must be（）valid certificate of nationality or certificated of registry or license.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

查找yuangong表中所有电话号码（列名：telephone）的第一位为8或6，第三位为0的电话号码（）

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。