We Learn SQL #13 | Intro to correlated subqueries in SQL

Подписаться 5 тыс.

Просмотров 18 тыс.

50% 1

See the difference between Subqueries and Correlated Subqueries in SQL. How to write them correctly and why they can be useful in your work.
If you want to learn or practice SQL, check out learnsql.com/.
Hi, I’m Adrian. Welcome to another video in the series about SQL basics. You should already know how to write subqueries that return single and multiple values, how to use ANY and ALL, and how to write subqueries in the FROM clause. In this clip, we’ll talk about yet another one: correlated subqueries in SQL. What are these? Let’s find out together.
👌 Subscribe to our channel and leave a comment!
👌 Do you want to learn SQL? Go to LearnSQL.com and choose the course or track that is best for you!
👌 Join us on Facebook: / welearnsql
🔊 Music: www.bensound.com/

Наука

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@chocolatechipturtle 2 года назад

Thank you for this video! Love the diagrams showing what matches to what. These are great examples for someone totally new to correlated subqueries!

@AhmedShaams Год назад

The background music sound is very annoying 😐

@VeronicaAngryPolak Год назад

this is my favorite video explaining correlated and uncorrelated subqueries. thank you

@petertavaszi5598 Год назад

Amazing explanation! Makes it a lot easier to understand! Thanks

@someshyadav6043 2 года назад

can you please remove the music in future videos as it makes it difficult to watch in higher speeds and most students like me usually go through at 1.5 -2x speeds

@veeek8 9 месяцев назад

Brilliant thank you

@avijitdey992 Год назад

great explanation

@skarthikreddy938 2 года назад

In the first example if the sub query returns more than one row then the query should look like this right ? SELECT name FROM country WHERE id IN ( SELECT country_id FROM city WHERE city.population = country.population AND country.id = city.country_id);

@ravishmahajan9314 6 месяцев назад

What will happen if we put reverse in subquery City. Countryid = bigCity.CountryID? Is this same?

@frshtmrrwfy Год назад

I couldn't understand that correctly due to my english level and the understanding skill but I'm thinking that correlated subquery like using equal means it's a thing like "group by".