Scribd
Upload
13 views3 pages

Understanding Subqueries in SQL

A subquery is a query nested within another query, also known as an inner or nested query. It must be enclosed in parentheses and executes first to provide output for the outer query. An example includes finding the name, location, and number of students in section A.

Uploaded by

south hits
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views3 pages

Understanding Subqueries in SQL

A subquery is a query nested within another query, also known as an inner or nested query. It must be enclosed in parentheses and executes first to provide output for the outer query. An example includes finding the name, location, and number of students in section A.

Uploaded by

south hits
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Subquery

Subquery
A subquery is a query within another query

Example of sub-query

Find Name, Location,


Number of section A
student
Subquery
A subquery is a query within another query

- Also called inner query/ nested


query
- It is a part of outer query
- Subquery must be enclosed in
parentheses
- Subquery will run first and return
the output for outer query

You might also like