---
title: "What is sub query and its properties?"  
description: "What is sub query and its properties?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-09  
updated: 2021-11-09  
canonical: https://www.mindstick.com/forum/156810/what-is-sub-query-and-its-properties  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# What is sub query and its properties?

What is sub [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) and defines its [properties](https://www.mindstick.com/articles/23331/nootropics-7-different-types-and-their-unique-properties)?

## Replies

### Reply by Steilla Mitchel

## SQL subquery and its property:

A subquery is often used inside a main query like Select, Update, Insert or Delete statements. A subquery can be used when expression is allowed. A subquery is also used to create a temporary table on which the main query is executed. Properties of sub query can be defined as follow

• Order By clause is not used with Subquery in SQL

• A sub query should be written in the right side of the comparison operator of the main query.

• A subquery is enclosed within the parenthesis because it is execute first before the main query.

• More than one sub query can be included in a main query.

## Types of Subquery

There are generally three types of sub query –

• Single row sub query. It is returns only one row

• Multiple row sub query. It returns multiple rows

• Multiple column sub query. It returns multiple columns to the main query. Main query is executed according the sub query result.

Example-

![What is sub query and its properties?](https://www.mindstick.com/mindstickforums/40edcd52-4c72-43e2-8b00-d8a8746c8fdd/images/f0a16220-8fce-4de4-aacc-8598587da6b8.png)

![What is sub query and its properties?](https://www.mindstick.com/mindstickforums/40edcd52-4c72-43e2-8b00-d8a8746c8fdd/images/00f89e92-1b11-4c5a-803a-87f0d04419bb.png)\


---

Original Source: https://www.mindstick.com/forum/156810/what-is-sub-query-and-its-properties

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