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;
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;
相关考题：
We will do our best to ( ) shipment to meet your requirements in time. A.expectB.expediteC.exerciseD.examine
Excel 2003的默认工作表分别命名为()A：Sheetl，Sheet2，Sheet3，Sheet4，Sheet5B：Book1，Book2，Book3，Book4，Book5C：Table1，Table2，Table3，Table4，Table5D：List1，List2，List3，List4，List5
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.
After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.
找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的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)
Excel的默认工作表分别命名为______。 A.Sheetl，Sheet2，Sheet3，Sheet4，Sheet5B.Table1，Table2，Table3，Table4，Table5C.List1，List2，List3，List4，List5D.Book1，Book2，Book3，Book4，Book5
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"))