SQL Aggregate Functions
How to Program with Java Podcast5 Juni 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!

Avsnitt(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 Juli 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 Juli 201813min

Populärt inom Business & ekonomi

badfluence
framgangspodden
varvet
rss-jossan-nina
rss-svart-marknad
rss-borsens-finest
avanzapodden
uppgang-och-fall
rss-dagen-med-di
lastbilspodden
fill-or-kill
svd-tech-brief
rss-inga-dumma-fragor-om-pengar
24fragor
rss-kort-lang-analyspodden-fran-di
rss-den-nya-ekonomin
kapitalet-en-podd-om-ekonomi
dynastin
borsmorgon
rikatillsammans-om-privatekonomi-rikedom-i-livet