Question · SQL and MySQL course · Module 10: Transactions and advanced SQL
Window functions and rows
What distinguishes window functions from ordinary aggregation with GROUP BY?
Answer options
- Window functions always return only one row
- Window functions remove text columns from the result
- Window functions work only on empty tables
- Window functions keep all rows and add the calculation alongside them
You can check the correct answer by solving this task in the CodeWorlds game.