Тёмный

We Learn SQL #14 | Correlated subqueries with EXISTS in SQL 

We Learn SQL
Подписаться 5 тыс.
Просмотров 13 тыс.
50% 1

We’re going to talk about a new SQL operator named EXISTS, and how we can use it along with correlated subqueries.
If you want to learn or practice SQL, check out learnsql.com/.
Hello, I’m Adrian and this is another video in the series about SQL basics. You already know quite a lot about subqueries in SQL. In the previous video, we introduced correlated subqueries. Expand your arsenal with another SQL operator - EXISTS. Learn how to use them effectively and how to write better and clearer SQL queries.
Regardless of whether you are just starting your adventure with SQL or you are already an advanced user - I recommend our We Learn SQL channel and my short clips on the basics of SQL. I have recorded episodes about SQL JOINs, SQL Group by clause, and many more. Watch them and give them a thumbs up.
👌 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/

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

 

10 авг 2020

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@stri06
@stri06 2 года назад
the information is clear but please do not ad music it's very distracting
@shaistachattha8508
@shaistachattha8508 2 года назад
I find your teaching method very helpful but the music keeps distracting me. Can you please remove the background music? Or at the least keep it very low.
@ajithshenoy5566
@ajithshenoy5566 2 года назад
the music is so annoying
@Sumfinfunny777
@Sumfinfunny777 Год назад
great video. Maybe lower the music volume a tad little? Just a suggestion
@ank18
@ank18 Год назад
I like your videos. They are easy to understand but can you please get rid of the background music. it suppresses what you are saying in the video.
@shivamshekhar8027
@shivamshekhar8027 2 года назад
Stumbled upon your Channel today, and I gotta tell these are the simplest SQL videos out here.
@mn2410
@mn2410 2 года назад
Thanks for the video. Could you please remove the background music and speak a bit louder.
@TheProblembaer2
@TheProblembaer2 2 года назад
Hey Content creator, your videos are really great, and thank you. But please, coulde you reupload without music, it distracts me alottt!
@faisalabdo4600
@faisalabdo4600 Год назад
the music dude !!!!!
@anvarichn
@anvarichn Год назад
Writing this comment to complaint on too loud music - Hopefully that can be fixed!
@bigbeast007
@bigbeast007 День назад
Think the output shown in video for "WHERE NOT EXISTS" is incorrect. It should fetch 2 values instead of 1. It should be "Magical Products" and "Amazing Stuff" as both of them have items less than 1 $
@MagnusAnand
Quick and to the point !
@hendrag1174
@hendrag1174 Год назад
Thank you very much Adrian for this great video which I think the best video regarding the Exists clause.
@fromtonghua5018
@fromtonghua5018 Год назад
I like the small table examples.
@stickercode
I couldn't still get it. So , what is the real function of this exists though? If we, let's say remove it from your query sample, what will be fundamentally changed in the result set?
@martajumi.inranbows3285
@martajumi.inranbows3285 Год назад
świetne materiały, Adrian :)!
@awilson1989
@awilson1989 Год назад
sound is too low, can't hear you even on %100 :/
@sogolsaremi6306
@sogolsaremi6306 3 года назад
Great Videos!
@laszlogergelykiss3921
Music is bothering...
@scottyblesthunter5118
@scottyblesthunter5118 Год назад
the background music is so distracting
Далее
We Learn SQL #15 | SQL Subqueries in SELECT
3:28
Просмотров 11 тыс.
Документы для озокомления😂
00:24
SQL | NOT IN Vs NOT EXISTS (Which one to use?)
10:03
Просмотров 10 тыс.
How to do Subqueries in SQL with Examples
8:20
Просмотров 166 тыс.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Просмотров 127 тыс.
When to Use a Subquery in SQL
8:50
Просмотров 31 тыс.
Advanced SQL Tutorial | Subqueries
8:37
Просмотров 368 тыс.