What are subquery and its properties in SQL server?

Question

Krishnapriya Rajeev · Answer

Subqueries are queries that are placed inside another query. The outer query is called as the main query and the inner query is called the subquery.

Different types of subqueries are:

Single-row sub-query - the sub-query returns only one row.
Multiple-row sub-query - the sub-query returns multiple rows
Multiple column sub-query - the sub-query returns multiple columns.

Properties of subqueries include:

Subqueries can be used with SELECT, UPDATE, INSERT, or DELETE statements.
It can be placed in the WHERE clause, HAVING clause, and FROM clause.
It is enclosed in parentheses.
It is always placed on the right side of comparison operators.
We cannot use the ORDER BY clause in the subquery. But, we can use the GROUP BY clause, which performs the same function as the ORDER BY clause.
The inner query executes before its parent query and the results of an inner query are passed to the outer query.
BETWEEN operator is placed within the subquery and cannot be used with the subquery.

forum

What are subquery and its properties in SQL server?

Can you answer this question?

1 Answers