Bird
0
0

Which of the following is the correct syntax to specify a window frame using ROWS BETWEEN?

easy📝 Syntax Q3 of 15
PostgreSQL - Window Functions in PostgreSQL
Which of the following is the correct syntax to specify a window frame using ROWS BETWEEN?
AROWS BETWEEN 2 PRECEDING TO 1 FOLLOWING
BROWS BETWEEN 2 PRECEDING AND 1 FOLLOWING
CROWS FROM 2 PRECEDING TO 1 FOLLOWING
DROWS BETWEEN 2 PRECEDING AND FOLLOWING 1
Step-by-Step Solution
Solution:

  1. Step 1: Recall correct syntax format

    The correct syntax uses BETWEEN ... AND ... with PRECEDING and FOLLOWING keywords.

  2. Step 2: Validate options

    ROWS BETWEEN 2 PRECEDING AND 1 FOLLOWING matches the correct syntax exactly.

  3. Final Answer:

    ROWS BETWEEN 2 PRECEDING AND 1 FOLLOWING -> Option B

  4. Quick Check:

    Syntax uses BETWEEN ... AND ... [OK]
Quick Trick: Use BETWEEN ... AND ... for window frames [OK]
Common Mistakes:
  • Using TO instead of AND
  • Wrong keyword order
  • Missing BETWEEN keyword

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Aggregate Functions and GROUP BY - JSON aggregation with JSON_AGG - Quiz 13medium Common Table Expressions - Why CTEs matter in PostgreSQL - Quiz 1easy Full-Text Search - @@ match operator - Quiz 13medium JSON and JSONB - Creating JSON columns - Quiz 9hard JSON and JSONB - Inserting JSON data - Quiz 13medium Joins in PostgreSQL - Why joins are essential - Quiz 1easy Window Functions in PostgreSQL - SUM, AVG, COUNT as window functions - Quiz 8hard Window Functions in PostgreSQL - LAG and LEAD for row comparison - Quiz 1easy Window Functions in PostgreSQL - SUM, AVG, COUNT as window functions - Quiz 5medium Window Functions in PostgreSQL - NTILE for distribution - Quiz 2easy