SQL Interview Questions #37: What is a correlated subquery?

SQL code copied to buffer

Task 37:

What is a correlated subquery?

A correlated subquery is a synonym for a join.

A correlated subquery is a subquery that references a column from the outer query.

A correlated subquery is a type of subquery that is executed before the outer query.

A correlated subquery is a subquery that is executed independently of the outer query.

A correlated subquery is a synonym for a nested subquery.

A correlated subquery is a type of subquery that is always nested within another subquery.

Mark all correct answers and click the "Check!" button

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $29.58 Goal: $100.00

Progress: 30%

T-SQL Fundamentals by Itzik Ben-Gan

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

Login

Register