- 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
SQL EXISTS vs IN Quiz
This SQL quiz compares EXISTS and IN subqueries and their negated forms. You will see why NOT IN returns no rows when the list contains a NULL, how NOT EXISTS avoids it and what really differs between the two in modern databases.
Sample question
Question 1 of 10What does this print?
CREATE TABLE customers (id INTEGER, name TEXT);
CREATE TABLE orders (id INTEGER, customer_id INTEGER);
INSERT INTO customers VALUES (1, 'Ann'), (2, 'Bob'), (3, 'Cy');
INSERT INTO orders VALUES (10, 1), (11, 1), (12, 3);
SELECT name
FROM customers c
WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id)
ORDER BY name;
Show the answer
B. Ann
Cy EXISTS is true when the correlated subquery finds at least one row for that customer. Like IN, it never repeats a customer, no matter how many orders match.
What this quiz covers
EXISTS (correlated subquery)and its select listINvsEXISTSfor semi-joins- The
NOT INwith NULL trap - Fixing it with
NOT EXISTSorIS NOT NULL - How optimizers treat IN and EXISTS
Questions people ask
Do I need an account?
No. Anyone can play. Sign in to keep your XP, streak, badges and history.
Can I retake it?
Yes. Your best score is kept, and the questions and answers are shuffled each time.