SQL Subqueries

How can we filter records using a dynamically computed value from another query?

Intermediate⏱ 2 Minutes⭐ 230 XP

🤔 THE QUESTION

How can we filter records using a dynamically computed value from another query?

💡 WHAT IS IT?

A scalar subquery is a nested query enclosed in parentheses that computes an intermediate value.

🎯 WHAT IS IT USED FOR?

Finding records above average, comparing against dynamic thresholds, multi-tier data lookup.

💻 EXAMPLE

SELECT *
FROM employees
WHERE salary > (
  SELECT AVG(salary)
  FROM employees
);

Practice typing production-grade SQL code for SQL Subqueries.