Question · SQL and MySQL course · Module 10: Transactions and advanced SQL

The PARTITION BY clause

What is PARTITION BY in a window function used for?

Answer options

  • It physically splits the table into several files on disk
  • It removes duplicates before computing the result
  • It divides rows into groups and computes the window function separately within each group
  • It sorts the final result instead of ORDER BY

You can check the correct answer by solving this task in the CodeWorlds game.