In SQL window functions, what does ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING produce?

Question

SQL Data Analyst — Medium

In SQL window functions, what does ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING produce?

Accepted Answer

ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING in SQL window functions produces the aggregate computed over the entire partition, regardless of the current row position. This means it includes all rows in the partition, not just a subset.