当在SELECT查询语句的from选项中，实现对表的右连接功能时，使用的保留字为（)。

A.select * from 学生表 order by 入校总分 asc

B.select * from 学生表 order by 入校总分 desc

C.select top 3 * from 学生表 order by 入校总分 asc

D.select top 3 * from 学生表 order by 入校总分 desc

A.A.TO

B.B.INTO

C.C.ORDER BY

D.D.GROUP BY

A.A.SELECT * FROM product WHERE max(price)>'一次性纸杯'

B.B.SELECT * FROM product WHERE price>(SELECT max(*) FROM product WHEREpName= '一次性纸杯')

C.C.SELECT * FROM product WHERE EXISTS pName='一次性纸杯'

D.D.SELECT * FROM product WHERE price>(SELECT max(price) FROM productWHERE pName='一次性纸杯')

A.A.select 学号 姓名 from student

B.B.select * from student

C.C.select 学号，姓名,性别 from student

D.D.以上都对

A.A.SELECT empno,ename FROM empWHERE empno=(SELECT empno FROM dept WHERE dname="研发部")

B.B.SELECT empno,ename FROM empWHERE deptno=(SELECT deptno FROM dept WHERE dname='研发部')

C.C.SELECT empno,ename FROM empWHERE deptno=(SELECT * FROM dept WHERE dname='研发部')

D.D.SELECT empno,ename FROM deptWHERE deptno=(SELECT deptno FROM emp WHERE dname="研发部")

A.函数必须使用的保留字def

B.程序在函数中报错，不会影响到程序的执行

C.可以向函数传入任何类型的参数

D.函数中可以存在多条return语句

A.limit

B.distinct

C.del

D.from

A.select count(*) from emp

B.select avg(*) from emp

C.select min(*) from emp

D.select max(*) from emp

A.SELECT*FROMsys.statements_with_errors_or_warnings

B.SELECT*FROMsys.statements_with_runtimes_in_95th_percentile

C.SELECT*FROMsys.statement_analysis

D.SELECT*FROMsys.host_summary_by_file_io