SUB QUERIES in SQL/Oracle

subquery
A subquery is a query within a query for the same or different table.The inner query is enclosed in parentheses ().The result of the inner query would be given as input to the outer query.Subqueries enable you to write queries that select data rows for criteria that are actually developed while the query is executing at run time.Sub-queries can be used in SELECT, FROM, WHERE and HAVING clauses. There are four broad divisions of subqueries: - Single-row subqueries: Subquery which r...
Read More