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

Поделиться
HTML-код
  • Опубликовано: 10 авг 2020
  • 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/
  • НаукаНаука

Комментарии • 24

  • @stri06
    @stri06 2 года назад +19

    the information is clear but please do not ad music it's very distracting

  • @shaistachattha8508
    @shaistachattha8508 2 года назад +26

    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.

  • @Sumfinfunny777
    @Sumfinfunny777 Год назад +3

    great video. Maybe lower the music volume a tad little? Just a suggestion

  • @ank18
    @ank18 Год назад +6

    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.

  • @TheProblembaer2
    @TheProblembaer2 2 года назад +3

    Hey Content creator, your videos are really great, and thank you. But please, coulde you reupload without music, it distracts me alottt!

  • @shivamshekhar8027
    @shivamshekhar8027 2 года назад +1

    Stumbled upon your Channel today, and I gotta tell these are the simplest SQL videos out here.
    Waiting for more stuff!

  • @mn2410
    @mn2410 2 года назад +4

    Thanks for the video. Could you please remove the background music and speak a bit louder.

  • @anvarichn
    @anvarichn Год назад +2

    Writing this comment to complaint on too loud music - Hopefully that can be fixed!

  • @faisalabdo4600
    @faisalabdo4600 Год назад +1

    the music dude !!!!!

  • @hendrag1174
    @hendrag1174 Год назад

    Thank you very much Adrian for this great video which I think the best video regarding the Exists clause.

  • @MagnusAnand
    @MagnusAnand 7 месяцев назад

    Quick and to the point !

  • @ajithshenoy5566
    @ajithshenoy5566 2 года назад +8

    the music is so annoying

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

    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 :)!

  • @fromtonghua5018
    @fromtonghua5018 Год назад

    I like the small table examples.

  • @sogolsaremi6306
    @sogolsaremi6306 3 года назад

    Great Videos!

  • @awilson1989
    @awilson1989 Год назад +1

    sound is too low, can't hear you even on %100 :/

  • @laszlogergelykiss3921
    @laszlogergelykiss3921 10 месяцев назад

    Music is bothering...

  • @scottyblesthunter5118
    @scottyblesthunter5118 Год назад +2

    the background music is so distracting

  • @dimasfariznugroho583
    @dimasfariznugroho583 3 года назад

    please dont stop sharing :)
    and also we need indonesian translate language :(

  • @labibalmahdi1393
    @labibalmahdi1393 Год назад +1

    The background music is badly distracting

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

    Raise the music so we can’t hear you ❤

  • @shreyashachoudhary480
    @shreyashachoudhary480 Год назад

    SQL++