Union | SQL | Tutorial 16

Поделиться
HTML-код
  • Опубликовано: 2 окт 2024
  • 🦒❤️ www.giraffeaca...

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

  • @fleurrubbani7104
    @fleurrubbani7104 4 года назад +13

    I can't thank you enough for these tutorials. You are an amazing teacher.

  • @karlnordenstorm8816
    @karlnordenstorm8816 6 лет назад +4

    Think the rebranding is a good idea. You really are a good teacher and the fact that you teach so many languages is really useful. It makes this my go-to channel for learning new stuff. The name "Giraffe Academy" indicated there might be another teacher in another language, in which case I would not go to this channel by default.

  • @sarmadakram2188
    @sarmadakram2188 4 года назад +3

    Thanks for such nice tutorial. Is this possible to run update query after select query? Using union or any other trick.

  • @sakshiagarwal2240
    @sakshiagarwal2240 4 года назад +12

    Love how all the examples are from the series The office makes it more interesting for me to learn

    • @nandankumar-po4ck
      @nandankumar-po4ck 3 года назад

      I just observed, thx for highlighting it

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

      I was laughing so hard when I saw it xD

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

      Notice that Jan is not Levinson Gould *Michael's face reaction to the camera* ;)

  • @susovanghosh6050
    @susovanghosh6050 3 года назад +1

    Awesome teaching!

  • @Siddharth-uo6zw
    @Siddharth-uo6zw 3 года назад +2

    Thank u so much!
    can you make more advanced paid courses in SQL, Back end Developer with economical for students.
    you teach so well.

  • @e.b.3396
    @e.b.3396 4 года назад +2

    Very understandable explanations, thanks for this video

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

    I got a question, in the video where you put in the query
    SELECT salary
    FROM employee
    UNION
    SELECT total_sales
    FROM works_with;
    only 17 records show up, the second 55,000 does not show up. Why is that? I added emp_id to both select statements and it showed the proper 18. Thank you and awesome video series!

    • @yasseennandally5851
      @yasseennandally5851 4 года назад +4

      UNION will result in distinct values even tho you didn't mention the keyword DISTINCT.
      To get duplicates, u need to use UNION ALL

  • @nirlevy8234
    @nirlevy8234 5 лет назад +3

    Amazing teacher! many thanks

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

    What if we wanted a column where it tells us if the money is coming in or going out? How would we make a custom column for unions like that?

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

    is it possible to query to union. What I mean is after using union on multiple table is it possible to the pull out specific data from that union

  • @Lana-uc4bl
    @Lana-uc4bl 4 года назад +1

    good explanation. thanks

  • @raquelnavarro879
    @raquelnavarro879 4 года назад +1

    This was very helpful, thank you so much!

  • @bishalsaha2468
    @bishalsaha2468 4 года назад +1

    i wanna get in touch with you, how do i sir ?

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

    so touching for an excellent video

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

    hahahaha these are the office characters.
    nice

  • @谭政-b9v
    @谭政-b9v 2 года назад

    「目標を指定してお金が必要」、

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

    where can I get the soure code ?

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

    Thanks!! This was very helpful

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

    thank you i'm using sqlServer and i find this really usefull

  • @shamkentemirgaliyev8549
    @shamkentemirgaliyev8549 8 месяцев назад

    Thank you for teaching! сиз берген такириптер оте унап тур!

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

    ty

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

    thanks sir

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

    Amazing.

  • @HiruniAbeysekara-fl1ij
    @HiruniAbeysekara-fl1ij Месяц назад

    Superb 🎉❤

  • @mohamedelshehaby2587
    @mohamedelshehaby2587 4 года назад

    thanks for your simplicity

  • @seiinpock
    @seiinpock 4 года назад

    Thank you this is super helpful

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

    thank you for these!!

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

    Fabulous!
    God bless you!

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

    You are the best!

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

    So good tutorial

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

    great tutorial!

  • @pandeyishita
    @pandeyishita 5 лет назад

    Tutorial on R language please.