题目内容

查找student 表中所有电话号码(列名: telephone)的第一位为1,第四位为1到5的电话号码()

A. SELECT telephone FROM student WHERE telephone LIKE ‘1__[1-5]%‘
B. (下划线2个)
C. B.SELECT telephone FROM student WHERE telephone LIKE ‘1_[1-5]%‘
D. (下划线1个)
E. C.SELECT telephone FROM student WHERE telephone LIKE ‘1%[1-5]%‘
F. D.SELECT telephone FROM student WHERE telephone LIKE ‘1%%[1-5]%‘

查看答案
更多问题

以下属于BIM核心建模软件的是()

A. Bently architecture
B. ArchiCAD
C. SketchUp
D. Revit

器官病理学的创始人是()

A. Virchow
B. William Osler
C. Morgagni
D. Paget James

假设要向表memebers中增加一个scores列,下面语句正确的是()

ALTER TABLE memebers ADD scores INT
B. ALTER TABLE memebers ADD COLUMN scores INT
CREATE TABLE memebers ADD COLUMN scores INT
D. CREATE TABLE memebers ADD scores INT

创建数据库的命令是()

A. create database
B. alter database
C. drop database
D. create table

答案查题题库