Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
MySQL Database Tutorial – 20 – Subqueries
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
33 responses to “MySQL Database Tutorial – 20 – Subqueries”
~THANKYOU BUCKY~
Splendid and not at all useless example.
Well explained
FINALLY SOME1 WHO SPEAKS DE ENRISHHHHH!!!
You're a madman Bucky. A madman!!! props on the video(s)
I wish you were my professor
You're the best teacher, INCEPTION is the perfect example for sub-queries.
Hi can I know if you have a subqueries tutorial using sql management studio?
Thank you so much. You made this so easy for me.
Maybe jump to the FINAL video and get the diploma ???
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?
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.
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
Damn bro you are saving my ASS! I LOVE THESE VIDEOS! THANK YOU FOR MAKING THEM! SERIOUSLY! THANK YOU a thousand times!
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!
You blow my mind with this examples
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.
legend, simply just THE legend.
you would do the same just use the formula and if so use more Subqueries
This example wasn't useless at all. It was perfect example, very similar to those we learn at school :).
How to get the median, then?
congratulations for the video guy ..not be silent, addressing more issues on your channel rsrsrssr
you were a genius a year ago !
HVALA 😀
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
thanks!
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!
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!
This is not a useless example .. Definitely not .. I have been struggling to understand this and you made it obvious !! Thankyou !!!
Can you please explain me derived table ?
thanks bucky that was an explanation neat !
than you. sensei
thank u