Nested Scalar Queries

Nested Queries

In this lesson we’ll examine nested queries, a query within another query. With the ability to nest a query, we can combine queries to get the desired result in a single uber query rather than executing each constituent query individually. Nested queries are generally slower but more readable and expressive than equivalent join queries. Also, in some situations nested queries are the only way to retrieve desired information from a database.

Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/30lesson.sh and wait for the MySQL prompt to start-up.