SQL Aggregate Functions

How to Program with Java Podcast

Content provided by Best Java podcast on iTunes, learn about variables, control structures, collections, data types, des, Best Java podcast on iTunes, Learn about variables, and Control structures. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Best Java podcast on iTunes, learn about variables, control structures, collections, data types, des, Best Java podcast on iTunes, Learn about variables, and Control structures or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

10y ago 32:12

MP3•Episode home

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

#Java #Prog Languages #Programming #Best Java podcast on iTunes #Learn about variables #Tech #Higher Education #Code #Podcasting Education #Control Structure #Tutorials