Subqueries in SQL (Inner Queries, Nested Queries)

preview_player
Показать описание
A subquery is a query embedded inside another one. They are sometimes called inner queries or nested queries.
Рекомендации по теме
Комментарии
Автор

Your teachings are better from the courses I enrolled online. Thanks!

icebear
Автор

Could you have returned the same search results using an INNER JOIN on the Customer ID key between the Orders table and Customers table and then applying the where clause to get the desired result for the year? If so, what is the advantage of using the nested query rather than the INNER JOIN?

sdwivedi