Aggregate Functions
| MIN | returns the smallest value in a given column |
| MAX | returns the largest value in a given column |
| SUM | returns the sum of the numeric values in a given column |
| AVG | returns the average value of a given column |
| COUNT | returns the total number of values in a given column |
| COUNT(*) | returns the number of rows in a table |
Aggregate functions are used to compute against a "returned column of numeric data" from your SELECT statement. They basically summarize the results of a particular column of selected data.
Hello , Would you mind sharing your contact email/phone number ? I need some info on Process Mfg
ReplyDelete