1. User's Guide
  2. Case Studies
  3. Case 2: A More Complex Query

3.6 Case 2: A More Complex Query

Demonstration using more complex queries.

Case 2 demonstrates the following:

  • The functions SUM(expression) and NVL(expr1, expr2) in the SELECT list
  • The GROUP BY and HAVING clauses

This query retrieves the departments from GTW_EMP whose total monthly expenses are higher than $10,000.

Parent topic: Case Studies