Question

What is the facility that allows nesting one select statement into another?

(a) nesting

(b) binding

(c) subquerying

(d) encapsulating

I had been asked this question during an interview for a job.

This interesting question is from Perl Script Characteristics in section MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

The correct choice is (c) subquerying

Best explanation: The ‘subquerying’ support provided by MySQL is a capability that allows writing one ‘SELECT’ statement within parentheses and nesting within another. This allows logically selecting content from tables.