SQL Server Sub-query Questions and Answers

A subquery is a query within a query. These sub queries are created with SQL statements. These subqueries are embedded within SELECT, FROM or the WHERE clause........
Sub Query Example with IN: Displays employees from employee table with bonus > 1000. Using IN first all employees are selected and compared to each row of the subquery.........
Comparison operators can be used (like <, >, =, !> etc). Sub queries used with comparison........
A subquery with Exist does not really return any data; it returns TRUE or FALSE........