PostgreSQL - Window Functions in PostgreSQL
Which of the following is the correct way to include
PARTITION BY in a window function in PostgreSQL?Which of the following is the correct way to include PARTITION BY in a window function in PostgreSQL?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Syntax of window functions
Window functions use OVER() with optional PARTITION BY and ORDER BY clauses inside parentheses.Step 2: Correct placement
PARTITION BY must appear inside OVER(), before ORDER BY if both are used.Final Answer:
SELECT name, SUM(sales) OVER (PARTITION BY region ORDER BY date) FROM sales_data; -> Option DQuick Check:
PARTITION BY goes inside OVER() clause [OK]
Quick Trick: PARTITION BY must be inside OVER() clause [OK]
Common Mistakes:
- Placing PARTITION BY outside the OVER() clause.
- Swapping ORDER BY and PARTITION BY order inside OVER().
- Using PARTITION BY as a standalone clause.
Master "Window Functions in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes