Examine the description of the EMPLOYEES table: Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and…

The correct answer is D. SELECT dept_id, MIN(salary), MAX(salary). This SELECT statement shows correct result. Incorrect Answers A: To provide correct data statement needs also GROUP BY clause. B: This statement will not provide correct results. C: HAVING clause can be used only in conjunction with GROUP BY clause. E: You need only grouping by…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?

Exhibit

Options

ASELECT dept_id, MIN(salary(, MAX(salary)
BSELECT dept_id, MIN(salary), MAX(salary)
CSELECT dept_id, MIN(salary), MAX(salary)
DSELECT dept_id, MIN(salary), MAX(salary)
ESELECT dept_id, MIN(salary), MAX(salary)

How the community answered

(39 responses)

A
3% (1)
B
13% (5)
D
79% (31)
E
5% (2)

Explanation

This SELECT statement shows correct result. Incorrect Answers A: To provide correct data statement needs also GROUP BY clause. B: This statement will not provide correct results. C: HAVING clause can be used only in conjunction with GROUP BY clause. E: You need only grouping by department, not by salary.

Topics

#GROUP BY#HAVING clause#MIN MAX#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice