PostgreSQL - Window Functions in PostgreSQL
If you use
NTILE(4) on 10 rows, how many rows will be in the first bucket?If you use NTILE(4) on 10 rows, how many rows will be in the first bucket?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Calculate base size per bucket
10 rows divided by 4 buckets gives 2 rows per bucket with 2 extra rows to distribute.Step 2: Distribute extra rows to first buckets
The first 2 buckets get 3 rows each, the last 2 get 2 rows each.Final Answer:
3 -> Option DQuick Check:
NTILE distributes extra rows starting from first bucket [OK]
Quick Trick: Extra rows go to first buckets when dividing with NTILE [OK]
Common Mistakes:
- Assuming all buckets have exactly equal rows
- Ignoring leftover rows when dividing
Master "Window Functions in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes