| Name the different Types of Subquery in SQL Server?
Below are the different types of Subquery in SQL Server:-
(1)Subqueries with table aliases
(2)Subqueries with EXISTS and NOT EXISTS
(3)Subqueries with IN and NOTIN
(4)Subqueries in UPDATE, INSERT and DELETE statements
(5)Subqueries with comparison statements
(6)Comparison operators modified by ANY, All or SOME | | |