The value returned by the subquery is used by the main query.

Keep practicing — related questions

• A subquery is a SQL query that inserts a record into a table.
• Can we use a subquery in insert statement
• There are also multiple-column subqueries: Queries that return more than one column from the inner SELECT s...
• The Query has Main and Sub Query. If the main query returns 10 records and subquery returns 5 records, then...
• Which operator compares a value to every value returned by a subquery?
• Which operator compares a value to every value returned by a subquery?
• Which operator compares a value to every value returned by a subquery?
• Which operator compares a value to every value returned by a subquery?