Multiple choice

Which of the following statements is/are true about having and group by clause? (a) Group by clause can work alone. (b) Having clause can work alone. (c) If group by clause is used, then having clause must be used in a query. (d) The having clause is used only if group by clause is used in a query.

  1. Only c

  2. a and b

  3. a, b, c and d

  4. a and d

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The having clause is used only if group by clause is used in a query.

Keep practicing — related questions