题目内容
(请给出正确答案)
[单选题]
SELECT查询语句中()关键词引起查询涉及的表。
A.SELECT
B.FROM
C.WHERE
D.ORDERBY
查看答案
如果结果不匹配,请 联系老师 获取答案
A.SELECT
B.FROM
C.WHERE
D.ORDERBY
A.select*fromemployeeswheresalary>(selectmin(salary)fromemployeesgroupbydepartment.id)
B.select*fromemployeeswheresalary=(selectavg(salary)fromemployeesgroupbydepartment_id)
C.selectdepartment_idfromemployeeswheresalary>all(selectavg(salary)fromemployeesgroupbydepartment_id)
D.selectlast_namefromemployeeswheresalary>any(selectmax(salary)fromemployeesgroupbydepartment_id)