SQL Aggregate Functions
How to Program with Java Podcast5 Jun 2014

SQL Aggregate Functions

In today's podcast episode you'll be learning all about the aggregate functions that exist in SQL.

What the heck is an aggregate function? Well that's what I'm going to try and teach you today, and I promise, it's not a difficult concept to grasp. Just think of an aggregate function as a method that you're calling that will process data in your database and return a value. Obviously the returned value will depend on which of the aggregate functions you choose to use.

So that begs an obvious question, what are the aggregate functions that we can use in SQL? I'm glad you asked, here's the ones that I use all the time in MySQL:

  • MAX
  • MIN
  • SUM
  • AVG
  • COUNT

Okay, great! So now we know what the names of these functions are, now let's see some examples of them in use!

Episoder(112)

EP41 - 5 Tips on Landing an Entry Level Programming Job

EP41 - 5 Tips on Landing an Entry Level Programming Job

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

16 Sep 201915min

EP40 - The Document Object Model (DOM)

EP40 - The Document Object Model (DOM)

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

4 Sep 201813min

EP39 - Arrays in JavaScript

EP39 - Arrays in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

27 Aug 201842min

EP38 - JavaScript's Built in Objects

EP38 - JavaScript's Built in Objects

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

20 Aug 201823min

EP37 - Null vs Undefined in JavaScript

EP37 - Null vs Undefined in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

14 Aug 201813min

EP36 - Objects in JavaScript

EP36 - Objects in JavaScript

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

6 Aug 201820min

EP35 - JavaScript TypeOf Keyword

EP35 - JavaScript TypeOf Keyword

Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootc...

30 Jul 201814min

EP 34 - Getting and Showing Data from Users

EP 34 - Getting and Showing Data from Users

Show notes for this episode are available via http://coderscampus.com/34 Don't forget to check out our current "deal" for coders campus available via http://coderscampus.com/deal

23 Jul 201813min

Populært innen Business og økonomi

stopp-verden
lydartikler-fra-aftenposten
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
finansredaksjonen
pengesnakk
pengepodden-2
tid-er-penger-en-podcast-med-peter-warren
rss-sunn-okonomi
utbytte
morgenkaffen-med-finansavisen
livet-pa-veien-med-jan-erik-larssen
stormkast-med-valebrokk-stordalen
rss-markedspuls-2
lederpodden
liberal-halvtime
rss-politisk-preik
okonomiamatorene