Go offline with the Player FM app!
SQL Aggregate Functions
Manage episode 163963616 series 1289539
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!
110 episodes
Manage episode 163963616 series 1289539
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!
110 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.