Sub Queries
Using a Sub-query :
Main Query: Which employees have salaries greater than Abel’s salary?
Subquery: What is Abel’s salary?
Sub-query
syntax :
The subquery (inner query)
executes once before the main query.
The result of the subquery is
used by the main query (outer query).