---
title: "What are the types of subquery?"  
description: "What are the types of subquery?"  
author: "Anonymous User"  
published: 2019-07-04  
updated: 2020-09-16  
canonical: https://www.mindstick.com/interview/23533/what-are-the-types-of-subquery  
category: "mssql server"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# What are the types of subquery?

These are two types of subquery – Correlated and Non-Correlated.

The correlated subquery cannot be considered as an independent query, but it can refer the column in a table listed in the FROM the list of the main query.

The Non-Correlated subquery can be considered as an independent query and the output of subquery are substituted in the main query.

## Answers

### Answer by Anonymous User

These are two types of subquery – Correlated and Non-Correlated.

The correlated subquery cannot be considered as an independent query, but it can refer the column in a table listed in the FROM the list of the main query.

The Non-Correlated subquery can be considered as an independent query and the output of subquery are substituted in the main query.


---

Original Source: https://www.mindstick.com/interview/23533/what-are-the-types-of-subquery

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.