📖
Theory
Understand the concept step by step
A subquery is a query nested inside another query.
Subqueries can appear in places such as WHERE, FROM or SELECT depending on the database system and query design.
💻
Example
See how the concept works in SQL
SQL
SELECT name
FROM employees
WHERE salary > (
SELECT AVG(salary)
FROM employees
);📤
Output
Understand what the query produces
Employees earning more than the average salary are returned.
📝
Practice
Test your understanding
Find products whose price is greater than the average product price.
❓
MCQs
Check your SQL knowledge
What is the main concept covered in Subqueries?
A.A query inside another query
B.A database inside a table
C.A table inside a column
D.A function inside a database
💼
Interview Questions
Prepare for SQL interviews
1
Interview Question
What is a subquery?
2
Interview Question
Where can subqueries be used?
3
Interview Question
What is a correlated subquery?