SQLINsubquerytutorial
What is IN with a subquery in SQL? Membership check for beginners
IN with a subquery filters "rows where a column's value appears in another query's result". Plain words: filtering by a dynamic list, the difference from a literal list, the NOT IN-with-NULL trap, and comparison with EXISTS. With tables and common pitfalls.
1 min čteníSQL · IN · subquery · tutorial
Procvičujte na reálných úlohách
Řešte úlohy v SQL trenéru s okamžitým hodnocením a nápovědami.
Otevřít trenéra
INis a membership check: a value must appear in a list. With a subquery, the list is computed by another SELECT — flexible and required for many real tasks.This article is currently in Russian. The full English translation is on the way.