MySQL + SQL · Lesson 71

Nested Queries and Subqueries

What is a Subquery?

A subquery (nested query) is a query inside another query. The inner query runs first; its result feeds the outer query.

Subquery in WHERE

-- students scoring above the average
SELECT name, marks FROM students
WHERE marks > (SELECT AVG(marks) FROM students);
The inner query finds the average; the outer keeps students above it.

Subquery with IN

-- students who have paid fees
SELECT name FROM students
WHERE roll_no IN (SELECT roll_no FROM fees);

Summary

  • A subquery is a query inside another; the inner runs first.
  • Common with WHERE, IN and comparison operators.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.