What does ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING as a window frame produce?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What does ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING as a window frame produce?

Key points

  • This window frame includes all rows in the partition
  • The current row position does not affect the calculation
  • Useful for getting overall partition statistics

Ready to go further?

Start full exam Practice more questions

Related questions