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.