Question:

What do you understand by a subquery? When is it used?

Answer:

A subquery is a SELECT statement embedded in a clause of another SELECT statement. It is used when the inner query, or the subquery returns a value that is used by the outer query. It is very useful in selecting some rows in a table with a condition that depends on some data which is contained in the same table.


Keywords:

© 2017 QuizBucket.org