Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)JOB_CAT VARCHARD2(30)SALARY NUMBER(8,2)Which statement shows the maximum salary paid in each job category of eac

题目

Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)JOB_CAT VARCHARD2(30)SALARY NUMBER(8,2)Which statement shows the maximum salary paid in each job category of each department? （）

A. SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);

B. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;

C. SELECT dept_id, job_cat, MAX(salary) FROM employees;

D. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

E. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;

相似考题

1.We will do our best to ( ) shipment to meet your requirements in time.A.expectB.expediteC.exerciseD.examine

2.Excel 2003的默认工作表分别命名为()A：Sheetl，Sheet2，Sheet3，Sheet4，Sheet5B：Book1，Book2，Book3，Book4，Book5C：Table1，Table2，Table3，Table4，Table5D：List1，List2，List3，List4，List5

3.Inthedatamodelyoucreatedthisquery:SELECTID_no,description,price,quantity,manufacturer_IDFROMinventoryNextyouclickanddragthemanufacturer_IDcolumnoutofandabovethedefaultgroup.YouneededtosortthechildgroupbyID_number.Howcouldyouaccomplishthistask?（）A.Addanorderbyclausetothequery.B.InthedatamodeldoubleclicktheID_numbercolumnandalterthebreakorder.C.InthelayoutmodeldoubleclicktheID_numberfiledandlatertheprintdirection.D.Defaultthelayout,chooseamaster/detailreportstyleandselectID_numberasthebreakorder.

4.I think the door is locked. But I'll go and ().A、checkB、examine

更多“Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2 ”相关问题

  • 第1题：

    After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.


    参考答案：being examined

  • 第2题：

    找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的SQL语句,(提示:使用

    NOT IN,NOT EXISTS,以及外部连接(+)三种方法),并说明那种方法是不优化的

    出版社: 出版社代码 char(2),出版社名称 varchar2(32)

    图书: 图书编号 char(8),图书名称 varchar2(128),出版社代码 char(2),作者代号

    char(4),图书简介 varchar2(128)

    作者: 作者代号 char(4),作者名称 varchar2(10),性别 char(1),年龄 number(3),文学

    方向 varchar2(64)

    获奖名单: 获奖日期 date,获奖人员 char(4)


    正确答案：
     

  • 第3题：

    He rolled up his trouer leg to exhibit his wounded knee.

    A:spread
    B:open
    C:show
    D:examine

    答案：C
    解析：
    本句意思：他卷起他的裤腿来显露受伤的膝盖。exhibit展示，显示。spread伸开，展开；open打开；show展示，出示；examine检查。

  • 第4题：

    检查

    A.expect

    B.except

    C.excuse

    D.examine


    正确答案：D

  • 第5题：

    Excel的默认工作表分别命名为______。

    A.Sheetl，Sheet2，Sheet3，Sheet4，Sheet5

    B.Table1，Table2，Table3，Table4，Table5

    C.List1，List2，List3，List4，List5

    D.Book1，Book2，Book3，Book4，Book5


    正确答案：A

  • 第6题：

    23、假定 number=4，下面哪个语句不会出错？

    A．print(format(number, "2d"), format(number ** 1.5, "4d"))

    B．print(format(number, "2d"), format(number ** 1.5, "4.2d"))

    C．print(format(number, "2d"), format(number ** 1.5, "4.2f"))

    D．print(format(number, "2f"), format(number ** 1.5, "4.2d"))


    正确

相关内容