Question: what is the difference between inline query and subquery?
Answer: A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. WHERE SALARY > 500) ; Inline Query is just the Select Statement . A Correlated subquery is a subquery that is evaluated once for each row processed by the outer query or main query.