Download MySQL : Aggregation Functions In SQL (AVG, COUNT, SUM, MIN, MAX) – Rull Full Version

welcome to wowaze site, you are on page MySQL : Aggregation Functions In SQL (AVG, COUNT, SUM, MIN, MAX) – Rull
Published on 2020-06-06 12:51:00 please download your needs here, and don’t forget to follow us by bookmarking this site.

You’re looking for #MySQL #Aggregation #Functions #SQL #AVG #COUNT #SUM #MIN #MAX #Rull And are in the right place because we have prepared for you, please enjoy.


Aggregation is a command that displays attribute values ​​in a table. Aggregation is usually used to display the total number of values, count the number of records, calculate the largest value, calculate the smallest value and calculate the average.

AVG (Calculating average)

COUNT (Counting the Number of Records)

SUM (Calculating Amount of Data)

MAX (Calculating Biggest Value)

MIN (Calculating Least Value)

AVG

The function of AVG itself is to display the average value of an attribute in the table, for example the average value of students as in the example below:

SELECT AVG(value) FROM mhs;

Then it will look like below:

+————+
| avg(value) |
+————+
| 83.3636 |
+————+
1 row in set (0.08 sec)

COUNT

The function of COUNT itself is to count the number of records for an attribute in the table, for example, the number of students who are counted is the number of students, as in the example below:

SELECT COUNT

FROM MHS;

Then it will look like below:
+—–+
| nim |
+—–+
| 11 |
+—–+

1 row in set (0.06 sec)

SUM

The function of SUM is to calculate the sum of the total values ​​of an attribute in the table, for example, counting all the MHS values, as in the example below:

SELECT SUM(value) FROM mhs;

Then it will look like below:
+————+
| sum(value) |
+————+
| 917 |
+————+

1 row in set (0.12 sec)

MAX

MAX itself has a function to display the largest value of an attribute, for example displaying the largest value of all students, as in the example below:

SELECT MAX(value) FROM mhs;

Then it will look like below:
+————+
| max(value) |
+————+
| 97 |
+————+

1 row in set (0.07 sec)

MIN

MIN is the opposite of MAX, which displays the smallest value of an attribute, for example, displays the smallest value of MHS, as in the example below:

SELECT MAX(value) FROM mhs;

Then it will look like below:
+————+
| min(value) |
+————+
| 65 |
+————+

1 row in set (0.00 sec)





thank you for downloading MySQL : Aggregation Functions In SQL (AVG, COUNT, SUM, MIN, MAX) – Rull
, hopefully it can be useful for all of you. search for your other digital needs by using the search menu in the header of this site.