你可能喜欢
单项选择题
A.select firstname+’.’+lastnameas’name’from employee
B.select firstname+’.’+lastname=’name’from employee
C.select’name’=firstname+’.’+lastnamefrom employee
D.select firstname,lastname from employee
单项选择题
A.从学生表中选择名字为三个字,并且名为“歆”的所有记录
B.从学员表中选择姓名中第四个字是“歆”字的所有记录
C.从学员表中选择姓名为两个字并且其中第2个字是“歆”字的所有记录
D.从学员表中选择姓名中包含“歆”字且最后一个字是王字的所有记录
单项选择题
A.SELECT telephone FROM yuangong WHERE telephone LIKE’[8,6]%0*’
B.SELECT telephone FROM yuangong WHERE telephone LIKE’(8,6)*0%’
C.SELECT telephone FROM yuangong WHERE telephone LIKE’[86]_0%’
D.SELECT telephone FROM yuangong WHERE telephone LIKE’[86]_0*’
单项选择题
A.数据库对创建表的数量没有限制
B.创建数据库表示不能同时创建约束
C.创建数据库表的同时创建主键,实际上是在创建表后对表进行修改
D.创建数据库表的同时创建外键,实际上是在创建表后对表进行修改
单项选择题
A.GROUP BY WHERE HAVING
B.WHE REGROUP BY HAVING
C.WHE REHAVING GROUP BY
D.HAVING WHERE GROUP BY
单项选择题
A.Select email from student where email!=null
B.Select email from student where emailnotisnull
C.Select email from student where email<>null
D.Select email from student where emailisnotnull
单项选择题
A.select top3 cDiscription fromTvtype order by iprice asc
B.select cDiscription from Tvtype where max(iprice)>3
C.select top3 cDiscription from Tvtype order by iprice desc
D.selec tcDiscription max(iprice)from Tvtype order by iprice
单项选择题
A.select CustomerName,SalesDate from Sales group by CustomerName,SalesDate
B.select CustomerName,SalesDate from Sales order by CustomerName,SalesDate
C.select CustomerName,SalesDate from Sales group by CustomerNameorderbySalesDateDESC
D.select CustomerName,SalesDate from Sales order by CustomerName,SalesDateDESC