|
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........
|
