• Tuesday , 12 December 2017

MySQL Database Tutorial – 20 – Subqueries

Code Canyon



Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source

3d Ocean

Related Posts

33 Comments

  1. AJay Gupta
    August 13, 2017 at 12:12

    ~THANKYOU BUCKY~

  2. Dan Abubakar
    August 13, 2017 at 12:12

    Splendid and not at all useless example.

  3. Thomas Jones
    August 13, 2017 at 12:12

    Well explained

  4. Jr Lopez
    August 13, 2017 at 12:12

    FINALLY SOME1 WHO SPEAKS DE ENRISHHHHH!!!

  5. Irish Code
    August 13, 2017 at 12:12

    You're a madman Bucky. A madman!!! props on the video(s)

  6. Kristen Cabrera
    August 13, 2017 at 12:12

    I wish you were my professor

  7. Ezic
    August 13, 2017 at 12:12

    You're the best teacher, INCEPTION is the perfect example for sub-queries.

  8. Shirley Charlin Lee
    August 13, 2017 at 12:12

    Hi can I know if you have a subqueries tutorial using sql management studio?

  9. Diksha
    August 13, 2017 at 12:12

    Thank you so much. You made this so easy for me.

  10. 33t00p
    August 13, 2017 at 12:12

    Maybe jump to the FINAL video and get the diploma ???

  11. Konstantin Zyubin
    August 13, 2017 at 12:12

    I have one question. I try to simplify this query and run
    SELECT name, cost FROM items WHERE cost > avg(cost) ORDER BY cost DESC
    but get ERROR #1111 – Invalid use of group function. Can somebody explain me why? 

  12. Bob Freddy
    August 13, 2017 at 12:12

    could have mentioned how writing the AVG function as a sub query allows the calculation to stay 'up-to-date' and that a static avg value changes, causing this to be a good solution for a repeated query.

  13. hrrs01 - CSGO Gaming
    August 13, 2017 at 12:12

    I see why its useless, but if the avg value constantly changes we could take use of it… even tho i know u can do everything in a short query xD

  14. El Ar
    August 13, 2017 at 12:12

    Damn bro you are saving my ASS! I LOVE THESE VIDEOS! THANK YOU FOR MAKING THEM! SERIOUSLY! THANK YOU a thousand times!

  15. Colin Skow
    August 13, 2017 at 12:12

    I think he means it is a useless example because there is an easier way to code it. A good coder would write this same query in a simpler manner. It is a good example in that it shows how subqueries work, but a bad example in that does not show how a similar query should be coded. Thanks for your work, Bucky! 

  16. jcrldesigner
    August 13, 2017 at 12:12

    You blow my mind with this examples

  17. RaceFun Aps
    August 13, 2017 at 12:12

    Not useless, the avarage price will change each time there are a sell or a new listing, thx Bucky for some great videos, I can use it for my racecenter where results update each day.

  18. Krazor
    August 13, 2017 at 12:12

    legend, simply just THE legend.

  19. Krazor
    August 13, 2017 at 12:12

    you would do the same just use the formula and if so use more Subqueries

  20. LosEagle
    August 13, 2017 at 12:12

    This example wasn't useless at all. It was perfect example, very similar to those we learn at school :).

  21. movie627
    August 13, 2017 at 12:12

    How to get the median, then?

  22. CANAL LOGÍSTICO
    August 13, 2017 at 12:12

    congratulations for the video guy ..not be silent, addressing more issues on your channel rsrsrssr

  23. seifclubiste15
    August 13, 2017 at 12:12

    you were a genius a year ago !

  24. Adil Begić
    August 13, 2017 at 12:12

    HVALA 😀

  25. BaliLandandVilla
    August 13, 2017 at 12:12

    you can not write 463 because table later on can change so of course average can change later on .it is meaningless you write 463 there

  26. Turbolego
    August 13, 2017 at 12:12

    thanks!

  27. Stijn Hoste
    August 13, 2017 at 12:12

    Actually it is… You should use:

    Select name, cost FROM items WHERE cost > avg(cost)

    This is better for performance etc.

    Bucky is a champ!

  28. ChrisPTY507
    August 13, 2017 at 12:12

    This is not an useless query because if one the costs changes,then the value of 423 will no longer gives you the exact average of cost,so doing it as you did is the most effiient way (aside from using the AVG funcion on the cost column). *Inception!*…. Nice explained, thank you!

  29. sh op
    August 13, 2017 at 12:12

    This is not a useless example .. Definitely not .. I have been struggling to understand this and you made it obvious !! Thankyou !!!

  30. sh op
    August 13, 2017 at 12:12

    Can you please explain me derived table ?

  31. fredp
    August 13, 2017 at 12:12

    thanks bucky that was an explanation neat !

  32. REET911
    August 13, 2017 at 12:12

    than you. sensei

  33. nipuni malsara
    August 13, 2017 at 12:12

    thank u

Leave A Comment

You must be logged in to post a comment.