What is subquery in SQL with example?

A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.