首页 071 正文

Examine the description of the EMPLOYEES table: Which query is valid?

2020.2.1 071 68
Examine the description of the EMPLOYEES table: Which query is valid? 071-第1张

Examine the description of the EMPLOYEES table: Which query is valid?
A SELECT dept id, join date, SUM (salary) FROM employees GROUP BY dept id, join date;
B SELECT dept id, join date, SUM (salary) FROM employees GROUP BY dept id;
C SELECT dept id, MAX (AVG (Salary)) FROM employees GROUP BY dept id
D SELECT dept id, AVG (MAX (salary)) FROM employees GROUP BY dept id

答案:A

相关推荐:

评论

昵称*

邮箱*

网址