[Solved] What does the ROWS BETWEEN clause specify in a window function? — Ans: It defines the frame by counting rows relative to the current row position. | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

What does the ROWS BETWEEN clause specify in a window function?

AIt defines the frame by counting rows relative to the current row position.

BIt defines the frame by counting rows based on the value range in the ORDER BY column.

CIt filters rows before applying the window function.

DIt sorts the rows before applying the window function.

Step-by-Step Solution

Solution:

Step 1: Understand window frame types
Window frames can be defined by position (ROWS) or by value range (RANGE).
Step 2: Identify what ROWS BETWEEN does
ROWS BETWEEN counts rows relative to the current row's position, not by values.
Final Answer:
It defines the frame by counting rows relative to the current row position. -> Option A
Quick Check:
ROWS BETWEEN = position-based frame [OK]

Quick Trick: ROWS counts rows by position, RANGE counts by value range [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does the ROWS BETWEEN clause specify in a window function?