Question · SQL and MySQL course · Module 6: Aggregation and grouping
What GROUP BY is for
What is the GROUP BY clause used for?
Answer options
- It sorts the results in ascending order
- It removes duplicates from the result
- It splits rows into groups with the same value and lets you compute an aggregate for each group separately
- It joins two tables into one
You can check the correct answer by solving this task in the CodeWorlds game.