Which clause is used to group rows sharing a property so aggregate functions can be applied?

SQL Fundamentals Easy

SQL Fundamentals — Easy

Which clause is used to group rows sharing a property so aggregate functions can be applied?

Key points

  • GROUP BY is essential for applying aggregate functions.
  • It groups rows based on a specified column.
  • ORDER BY sorts rows but does not group them.
  • PARTITION BY is used in window functions, not for grouping.
  • CLUSTER BY is not a valid SQL clause.

Ready to go further?

Start full exam Practice more questions

Related questions