Using SQL Subqueries to Solve Queries
A Query with in a Query is called subqueries .SQL Subqueries to Solve Queries can be used any place where an expression is allowed, means a subqueries that returns a single value can also be listed as an object in FROM clause and it is treat like view and a virtual table.