what is sub queries in sql

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 … Read more