I Want to use subQuery in Sql server please help me.
Sub Queries In sql Server Anonymous User 1647 03 Dec 2015 I Want to use subQuery in Sql server please help me.
A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause.
A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.
Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.