What does the `OVER()` clause do in a window function?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What does the `OVER()` clause do in a window function?

Key points

  • The `OVER()` clause does not limit rows above the current row or filter rows after the calculation.
  • It does not move the result to a new column over existing data.
  • It specifically defines the window for the function to operate within.

Ready to go further?

Start full exam Practice more questions

Related questions