What is a Subquery?

Last Post

Posts: 12

kumar BI

Guest

Topic starter

Aug 04, 2020 11:08 am

(@kumar BI)

Active Member

Joined: 3 years ago

use of subquery.

Topic Tags

whatissubquery

1 Reply

Posts: 47

Ram DBA

Guest

Aug 05, 2020 4:13 am

(@Ram DBA)

Eminent Member

Joined: 3 years ago

A Subquery is a SQL query within another query. It is a subset of a Select statement whose return values are used in filtering the conditions of the main query.

Here is the simple subquery for your better understanding.

SELECT ProductName
FROM Product
WHERE Id IN (SELECT ProductId
FROM OrderItem
WHERE Quantity > 50)