Why might NTILE produce uneven bucket sizes when the total number of rows is not divisible by the number of buckets?

hard📝 Conceptual Q10 of 15

PostgreSQL - Window Functions in PostgreSQL

ABecause NTILE always creates empty buckets at the end

BBecause NTILE distributes leftover rows starting from the first bucket

CBecause NTILE ignores leftover rows

DBecause NTILE rounds down bucket sizes to nearest integer

Step-by-Step Solution

Solution:

Step 1: Understand NTILE distribution logic
When rows don't divide evenly, NTILE adds leftover rows to first buckets.
Step 2: Explain uneven bucket sizes
This causes some buckets to have one more row than others, starting from bucket 1.
Final Answer:
Because NTILE distributes leftover rows starting from the first bucket -> Option B
Quick Check:
Leftover rows go to first buckets in NTILE [OK]

Quick Trick: Leftover rows go to first buckets, causing uneven sizes [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free