Aug 04, 2020 11:08 am
use of subquery.
1 Reply
Aug 05, 2020 4:13 am
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)