Oracle Database and SQL Fundamentals

Casual Mode - Take your time!

1 / 20
✓
Correct
0
✗
Incorrect
0
★
Score
0%
Multiple Choice

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?

  1. Group By
  2. Where
  3. Select
  4. Having
Change Mode