• Friday , 10 April 2020

MySQL Database Tutorial – 18 – More on Aggregate Functions

Code Canyon



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

Original source

3d Ocean

Related Posts

36 Comments

  1. A Kane
    December 10, 2018 at 23:58

    Is shampoing supposed to be champagne?

  2. hasan anwar
    December 10, 2018 at 23:58

    5:1 😀
    yes sir

  3. Evgeni Kuzmov
    December 10, 2018 at 23:58

    you made me go to an eBay and browse stuff lol

  4. לירן זיידמן
    December 10, 2018 at 23:58

    Hi Bucky, do these MySQL clips you present here are only for begginers? or if I master all of that, does that covers most of what needs to be know by someone who works on a regular basis with MySQL scripts?
    Thanks man

  5. Science is Awesome!!
    December 10, 2018 at 23:58

    5700 must be the bikini. LMAO you're funny as hell.

  6. Miguel Gomez
    December 10, 2018 at 23:58

    I have a problem, when I order the database by the price, I should get the used car (id=33) as the maximum, however it appears in the middle:

    Linkbuzz | 582.75 | 67 | 49
    Muxo | 580.62 | 4 | 18
    used car | 5700.5 | 12 | 50
    Topicware | 549.39 | 3 | 11

    It seams that it takes 5700.5 as 570.05 but why?

  7. Marie Fonkou
    December 10, 2018 at 23:58

    Shampoing is the french word for Shampoo.
    Great video btw !

  8. Joseph Stoops
    December 10, 2018 at 23:58

    SELECT COUNT(dracula) FROM Transylvania WHERE time BETWEEN dusk AND dawn

  9. Syed Ahsan Ali
    December 10, 2018 at 23:58

    can we use Two queries in one statement using AND. For example SELECT AVG (cost) form items AND SELECT COUNT (name) FROM items WHERE seller=6

  10. Ryan Gilkey
    December 10, 2018 at 23:58

    Suuurrrrree… had someone else create the table. 

  11. Bob Fungus
    December 10, 2018 at 23:58

    Hey Bucky… I've got a question for you… I used a "," after "avg" on the third row and it didn't work. Why is that?
     
    SELECT COUNT(*) AS item_count,
    MAX(cost)AS max,
    AVG(cost)AS avg              <—————
    FROM items WHERE seller_id=12

  12. Caroline O
    December 10, 2018 at 23:58

    Have you ever thought that "Shampoing" is a poor spelling of "Champagne".. who knows (well i guess the writer).

  13. therob107
    December 10, 2018 at 23:58

    Great video!

  14. IamNixjust
    December 10, 2018 at 23:58

    Please teach us Oracle Bucky! 😀

  15. SVTXmOpHeaD
    December 10, 2018 at 23:58

    Dat one person who had to dislike …..

  16. amir marou
    December 10, 2018 at 23:58

    I like all your tutorials Bucky thank you

  17. Eric
    December 10, 2018 at 23:58

    DISTINCT SELECT DISTINCT name FROM customers

    LIMIT SELECT name, zip FROM customers LIMIT 5, 10

    OREDR BY SELECT name, id, address, state FROM customers ORDER BY state, name
    SELECT name, id, address, state FROM customers ORDER BY state DESC
    SELECT name, id, address, state FROM customers ORDER BY state DESC LIMIT 5

    * SELECT * FROM customers

    qualified name SELECT name. Address FROM customers

  18. The Ripper
    December 10, 2018 at 23:58

    THAT MUST'VE BEEN THE BIKINI

  19. sandeep reddy
    December 10, 2018 at 23:58

    Instead of using a function, you can directly multiply the value with 10.

  20. PuertoRico
    December 10, 2018 at 23:58

    Remember always makes sure you get the MAX AS

  21. Shiva Manhar
    December 10, 2018 at 23:58

    thank you

  22. nipuni malsara
    December 10, 2018 at 23:58

    thank u

  23. Cynthia
    December 10, 2018 at 23:58

    format output value*

  24. Cynthia
    December 10, 2018 at 23:58

    Hi,
    i was wondering what function i can use to formst out value to 1 place after the decimal.
    if you can help me please and thank you

  25. 6CMC9
    December 10, 2018 at 23:58

    $5700 must be the bikini lol

  26. Frubr
    December 10, 2018 at 23:58

    0:55 "used diaper from my sister" HOLY CRAP XD

  27. varukashotta
    December 10, 2018 at 23:58

    pretty cool huh

  28. Ari Falkner
    December 10, 2018 at 23:58

    @regalme There is a series of videos by TheNewBoston on C# at j(dot)mp/Hkwdc1

  29. Michael Hawkins
    December 10, 2018 at 23:58

    I always wash my hair with shampoing

  30. Chris Kavanagh
    December 10, 2018 at 23:58

    Hmmm, couldn't get this query to work. Error in ln 4 Where seller_id=12. Here's a paste of my commands, see if you can spot the error please???
    SELECT COUNT(*) AS item_count,
    MAX(cost) AS max,
    AVG(cost) AS avg,
    FROM items WHERE seller_id=12

  31. Chris Kavanagh
    December 10, 2018 at 23:58

    @gtech2012 LOL, Bucky ain't no joke. . .I wonder how much of this stuff he knew before he got to UNC??

  32. ThePurpleMaestro
    December 10, 2018 at 23:58

    one word for bucky "Helper"

  33. myITguy
    December 10, 2018 at 23:58

    Time for some C# ASP .NET videos!!! come on bucky

  34. Matthias Neuhauser
    December 10, 2018 at 23:58

    hahaha – bucky is selling the dirty diaper from his sister… 😉

  35. Артем МатЛектор
    December 10, 2018 at 23:58

    Good job!

  36. TheOnlyBrainsaw
    December 10, 2018 at 23:58

    more robot tutorials PLS!!!! 🙂

Leave A Comment

You must be logged in to post a comment.