- Executors
-
Learn
Learn Python Runnable examples, NumPy, pandas, and more Learn AI / Machine LearningNeural networks, ML and LLMs from scratch Learn C & C++ Pointers, memory, STL, and modern C++ Learn C#C# basics, OOP, LINQ, async, and .NET exercises Learn MatplotlibLine, bar, scatter and pie charts with live visualizers Learn RustOwnership, traits, error handling, and threads Learn GoSlices, interfaces, goroutines, and channels Python Algorithms Search, sorting, recursion, and visualizers O(n) C & C++ Algorithms Compare algorithms implemented in C and C++ Coding for Kids Learn to code by playing!
- QuizzesNew
- ChallengesNew
- For TeachersNew
- Updates
- Buy me a coffee
Subqueries & Window Functions Quizzes
Go past single SELECTs: subqueries, EXISTS, CTEs and window functions for rankings, running totals and row-to-row comparisons.
Intermediate
5 quizzes · 50 questions
about 34 minutes
0/5passed
Category exam
20 mixed questions. 80% earns a certificate.
1
Subqueries
Medium
Put a query inside a query and predict what scalar, IN, derived-table and correlated subqueries return.
#subqueries#correlated-subqueries
10 questions · ~6 min
Not started
Start
2
EXISTS vs IN
Medium
Choose between EXISTS and IN, and avoid the NOT IN trap that returns nothing when a NULL sneaks in.
#subqueries#null-handling
10 questions · ~6 min
Not started
Start
3
Common Table Expressions (WITH)
Medium
Name intermediate results with WITH and generate rows or walk hierarchies with recursive CTEs.
#cte#recursive-cte
10 questions · ~6 min
Not started
Start
4
ROW_NUMBER, RANK & DENSE_RANK
Hard
Number and rank rows with window functions and know exactly how each one treats ties.
#window-functions#ranking
10 questions · ~8 min
Not started
Start
5
Running Totals, LAG & LEAD
Hard
Build running totals, moving averages and row-to-row comparisons with window frames, LAG and LEAD.
#window-functions#running-totals
10 questions · ~8 min
Not started
Start
No quiz matches. Try another word or tag.