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.