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