[Solved] Which of the following is the correct syntax to use PARTITION BY in a window function? — Ans: SELECT col, SUM(value) OVER (PARTITION BY col ORDER BY date) FROM table; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Which of the following is the correct syntax to use PARTITION BY in a window function?

ASELECT col, SUM(value) OVER (PARTITION BY col ORDER BY date) FROM table;

BSELECT col, SUM(value) PARTITION BY col FROM table;

CSELECT col, SUM(value) OVER PARTITION BY col FROM table;

DSELECT col, SUM(value) WHERE PARTITION BY col FROM table;

Step-by-Step Solution

Solution:

Step 1: Identify correct window function syntax
The correct syntax uses OVER() with PARTITION BY inside parentheses.
Step 2: Check each option
SELECT col, SUM(value) OVER (PARTITION BY col ORDER BY date) FROM table; correctly uses SUM(value) OVER (PARTITION BY col ORDER BY date). Others misuse PARTITION BY outside OVER or with WHERE.
Final Answer:
SELECT col, SUM(value) OVER (PARTITION BY col ORDER BY date) FROM table; -> Option A
Quick Check:
Window functions use OVER() with PARTITION BY inside [OK]

Quick Trick: PARTITION BY must be inside OVER() parentheses [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to use PARTITION BY in a window function?