Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_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? （） -题库考试答案搜索网

Examine the description of the EMPLOYEES table:
EMP_ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_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? （）

单选题

2022-01-03 23:06

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

查看答案

正确答案

试题解析

标签： 1Z0-007

感兴趣题目

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHARD2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column?（）

（）shall be liable for loss of and damage to the Vessel and／or goods arising or resulting from inaccuracies in stating the description，quantity，weight，measurement or contents.

In the absence of exceptions clauses，there is（）obligation to supply a cargo of the contractual description and quantity.

Whenever visible traces of oil are observed on or below the surface of the water in the immediate vicinity of ship or its wake，Governments of Parties to the Convention should，to the extent they are reasonably able to do so，promptly（）the facts bearing on the issue of whether there has been a violation of the provisions of this Regulation or Regulation 10 of this Annex of MARPOL 73/78.

Which of the following descriptions of the Mississippi River is NOT true?

The master may bind the Shipowner or Charterer（）doing such things as are necessary on the part of the one or of the other to carry out the contract.

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

The life cycle of a project is a description of the various phases of the project from the beginning to the end. One of the followings is not a phase of the traditional project life cycleIt is().

Examine the description of the MARKS table:

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:

What is the result of the SELECT statement?（）

The prima facie rule that the law of the flag governs contracts of carriage by sea（）the paramount rule of the intention of the parties，which may be express，or implied from the circumstances of the sea.