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.