📚 Practice Mode

Oracle Database and SQL Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 20
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