---
title: "Define Subquery."  
description: "Define Subquery."  
author: "Manish Kumar"  
published: 2017-11-26  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23313/define-subquery  
category: "mssql server"  
tags: ["sql server", "sql server 2008"]  
reading_time: 1 minute  

---

# Define Subquery.

A subquery is simply s select statement that returns a single value and ca be nested inside a SELECT, UPDATE , INSERT, or DELETE statement. It is also possible to nest a subquery inside another subquery. According to MSDN subquery can be nested upto 32 level. Subqueries are always enclosed in parenthesis and are also called as inner queries.

## Answers

### Answer by Manish Kumar

A subquery is simply s select statement that returns a single value and ca be nested inside a SELECT, UPDATE , INSERT, or DELETE statement. It is also possible to nest a subquery inside another subquery. According to MSDN subquery can be nested upto 32 level. Subqueries are always enclosed in parenthesis and are also called as inner queries.


---

Original Source: https://www.mindstick.com/interview/23313/define-subquery

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