Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)

Question

Options

• AYou can use column alias in the GROUP BY clause.
• BUsing the WHERE clause after the GROUP BY clause excludes the rows after creating groups.
• CThe GROUP BY clause is mandatory if you are using an aggregate function in the SELECT
• DUsing the WHERE clause before the GROUP BY clause excludes the rows before creating
• EIf the SELECT clause has an aggregate function, then those individual columns without an

• A
  4% (2)
• B
  11% (5)
• C
  2% (1)
• D
  83% (38)

No community discussion yet for this question.