Oracle Database and SQL Fundamentals

Time: 00:00:00
0
Attempted
20
Not Attempted
0
Marked For Review
0
Attempted & Reviewed

Question 1 of 20

Consider the following SELECT statement: SELECT dept_no "Departments", MAX(salary) "Max Salaries" FROM employee WHERE dept_no IN(200, 300, 400) GROUP BY Departments HAVING MAX(salary) > 60000; Due to which clause does this statement fail?

Select Your Answer:

All Questions

Attempted
Not Attempted
Marked for Review
Attempted & Reviewed
Current