We Learn SQL #11 | Subqueries in SQL with operators ANY and ALL

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/

[@chrisolo2001]

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.

[@shankarghimire4492]

Thank you, Adrian!
Your videos are short and sweet.
Worth them to watch.
Really loved them.
Thanks!

[@oladman9058]

Your videos are so 'teaching friendly.' 4 minutes of your videos are worth more than their weight in gold. many thanks.

[@virginiatenoriovelasquez2019]

Thank you so much. I finally understood how they work 🥺

[@gpankov]

На английском объясняют понятнее чем другие блогеры на русском, спасибо, Автор!
They explain in English better than other bloggers in Russian, thank you Author!

[@-Corvo_Attano]

This man is a great teacher.
Subscribed

[@timesothanayongkul4923]

Thank you, I was confused about this for a bit. You video really cleared this up!

[@mohamednouri997]

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);

[@raccoon8230]

Thank you so much, Adrian!

[@ktswjp]

Simple and to the point 👍

[@MrBicholino]

What an amazing explanation! Congrats from Brazil.

[@user-es5ox2wo1k]

thanks, you are amazing lector!

[@fromtonghua5018]

Perfect easy and effective example!

[@dmitryfedyainov4788]

The best explanation. Thanks!

[@shreyashachoudhary480]

Amazing explanation!

[@C.Sakthivignesh]

Thank you so much sir for made this video.

[@logicalbeing155]

Great work keep it up 👍

[@IMdAbdulquadirKhan]

doing great work

[@Amdebirhan_Abebe]

Thank you !

[@sunchosamarancho41]

thank you for this video !

[@simplemente_humano]

great videos!

[@jawaherhs1217]

thank you thank you are lifesaver

[@salaarkalki]

thanks man

[@vimukthaariyasinghe8041]

great tutorial

[@abusuffian9221]

Thanks

[@Zealot02]

Thank you

[@phiphongnguyen3352]

thanks you

[@bakre_dev8728]

Great

[@sohker]

Okey..

[@deepquest]

You picked a very simple example, please do some more complex examples using ANY and ALL operator.

[@powerbis.1794]

ARE U HEISENBERG?

[@gonencgokcay4540]

why would you add background music to an educational video :(

[@alanbull4219]

Good video - but please ditch the annoying background music

[@shakib_04]

Q1: Is there any student older than all lecturers in the university?
Q2: Is there any lecturer who is younger than all students?

[@eliy5550]

DOESNT WORK