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

The OVER clause

What is the OVER clause in a window function used for?

Answer options

  • It ends the query instead of a semicolon
  • It defines the window (the ordering and optional groups) in which the function operates
  • It joins two tables into one
  • It removes rows that do not meet a condition

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