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.与SQLServer数据检索的速度无关
D.加快数据库打开的速度

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.LIMIT
B.TOP
C.COUNT
D.SUM

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