EPISODE · Jun 5, 2014 · 32 MIN
SQL Aggregate Functions
from How to Program with Java Podcast · host Trevor Page: Java Guru | Programmer | Teacher
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!
What this episode covers
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!
NOW PLAYING
SQL Aggregate Functions
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m