You issue the following query: SQL> SELECT AVG(MAX(qty)) FROM ord_items GROUP BY item_no HAVING AVG(MAX(qty))>50; Which statement is true regarding the outcome of this query?

Question

Options

• AIt executes successfully and gives the correct output.
• BIt gives an error because the HAVING clause is not valid.
• CIt executes successfully but does not give the correct output.
• DIt gives an error because the GROUP BY expression is not valid.

• A
  13% (9)
• B
  78% (52)
• C
  6% (4)
• D
  3% (2)

Explanation

The general form of the SELECT statement is further enhanced by the addition of the HAVING clause and becomes: SELECT column|expression|group_function(column|expression [alias]), ...} FROM table [WHERE condition(s)] [GROUP BY {col(s)|expr}] [HAVING group_condition(s)] [ORDER BY {col(s)|expr|numeric_pos} [ASC|DESC] [NULLS FIRST|LAST]]; An important difference between the HAVING clause and the other SELECT statement clauses is that it may only be specified if a GROUP BY clause is present. This dependency is sensible since group- level rows must exist before they can be restricted. The HAVING clause can occur before the GROUP BY clause in the SELECT statement. However, it is more common to place the HAVING clause after the GROUP BY clause. All grouping is performed and group functions are executed prior to evaluating the HAVING clause.

No community discussion yet for this question.