ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-097

047-097

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-18 14:48:14 0 删除 编辑
97. View the Exhibit and examine the description for EMPLOYEES and
DEPARTMENTS tables.Evaluate the following SQL statement:
SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) total
FROM employees e JOIN departments d ON e.department_id = d.department_id
GROUP BY CUBE (e.department_id, e.job_id, d.location_id);
Which two statements are true regarding the output of this command? (Choose
two.)
A. The output would display the total salary for all the departments.
B. The output would display the total salary for all the JOB_IDs in a
department.
C. The output would display only the grand total of the salary for all JOB_IDs
in a LOCATION_ID.
D. The output would display the grand total of the salary for only the groups
specified in the GROUP BY clause.
Answer: AB

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718867/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-096
下一篇: 047-098
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204246