How to use the SQL EXISTS and NOT EXISTS conditional operators

Поделиться
HTML-код
  • Опубликовано: 29 янв 2025

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

  • @nastygambler2522
    @nastygambler2522 2 года назад +2

    The legend is HERE.. Thank You for the video legend !!

    • @vladmihalcea
      @vladmihalcea  2 года назад

      You're welcome and stay tuned for more

  • @ConiCalaro
    @ConiCalaro 2 года назад +2

    Awesome video and direct explanation, thanks from Brazil

    • @vladmihalcea
      @vladmihalcea  2 года назад

      Thanks. I'm glad you liked it. This is part of my High-Performace SQL video course, so if you liked it, you are going to love the entire course.
      vladmihalcea.com/courses/high-performance-sql/

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

    Great explanation Sir.

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

      You're welcome. If you liked this episode, you are going to love my High-Performance SQL video course.

  • @afreen5058
    @afreen5058 3 месяца назад

    Thank you so much for the video, the editing and everything is very good for explaining queries! I finally think I can do my homework haha.
    I am unsure why we can't just use SELECT to get Alice with a grade of 10 rather than EXISTS.

    • @lightingvulture
      @lightingvulture 2 месяца назад

      I'm not sure but there is no student name column in the student_grades table but we have the ID. we use EXISTS because we don't want to join the 2 tables, otherwise you can use SELECT.

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

    Great explanation! Thank you

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

    Good job, thanks for posting to clarify it better for us.
    But,
    if you don't mind, this is for 10th grade delineation.
    And not having a grade score of 10 (and if you meant 10th grade, apologies in advance).
    Never mind, I see later on that you 'are' talking grades of 10, 9, 8, etc...

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

      In Europe, where I live, many countries use the 0-10 grade system, where 10 is the highest score.
      www.nuffic.nl/en/education-systems/european-baccalaureate/grades-and-study-results
      Hence, the example in this video.

  • @ImMouldyJim
    @ImMouldyJim 2 года назад

    Thanks!