We Learn SQL #11 | Subqueries in SQL with operators ANY and ALL
Вставка
- Опубліковано 8 чер 2020
- Discover uses of SQL Subqueries with ANY and ALL operators. Write better inquiries and work more efficiently.
If you want to learn or practice SQL, check out learnsql.com/.
Hello, my name is Adrian. Welcome to another video in the series about SQL basics. In the previous video ( • We Learn SQL #10 | Sub... ), we combined multiple return values from SQL subqueries with the IN operator. Today, we’ll talk about two more similar operators: ANY and ALL. Let’s get down to them!
Let’s learn SQL 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/ - Наука та технологія
Your videos are so 'teaching friendly.' 4 minutes of your videos are worth more than their weight in gold. many thanks.
This was an amazing explanation I've been just progressing through exercises like these with MIN() and MAX() until i encountered a problem that really required it.
Thank you, Adrian!
Your videos are short and sweet.
Worth them to watch.
Really loved them.
Thanks!
Thank you so much. I finally understood how they work 🥺
This man is a great teacher.
Subscribed
На английском объясняют понятнее чем другие блогеры на русском, спасибо, Автор!
They explain in English better than other bloggers in Russian, thank you Author!
thank you for this amazing explanation but the first one we can do like this select * from students where age > (select min (age ) from lecturer);
Thank you, I was confused about this for a bit. You video really cleared this up!
What an amazing explanation! Congrats from Brazil.
Simple and to the point 👍
Thank you so much, Adrian!
Thank you so much sir for made this video.
The best explanation. Thanks!
Perfect easy and effective example!
Amazing explanation!
thanks, you are amazing lector!
Thank you !
Great work keep it up 👍
doing great work
Thanks
great videos!
thank you for this video !
thank you thank you are lifesaver
great tutorial
thanks man
Thank you
Great
thanks you
Okey..
You picked a very simple example, please do some more complex examples using ANY and ALL operator.
ARE U HEISENBERG?
Good video - but please ditch the annoying background music
why would you add background music to an educational video :(
Q1: Is there any student older than all lecturers in the university?
Q2: Is there any lecturer who is younger than all students?
DOESNT WORK