Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 5
Advanced Querying with Subqueries
1
Subqueries in WHERE for Dynamic Filtering
Write a subquery in the `WHERE` clause to filter results based on a dynamic value.
2
Filtering with Subqueries: IN and NOT IN
Use `IN` and `NOT IN` with a subquery for set-based filtering.
3
Optimizing Existence Checks with `EXISTS` and `NOT EXISTS`
Use `EXISTS` and `NOT EXISTS` with a subquery for efficient existence checks.
4
Correlated Subqueries with Outer References
Write a correlated subquery that references columns from the outer query.
5
Subqueries in SELECT
Place a subquery in the `SELECT` clause to create a calculated column.
6
Querying Derived Tables with Subqueries
Place a subquery in the `FROM` clause to query a derived table.
Previous module
Aggregation and Grouping
Next module
Organizing Queries with CTEs