• AVG (): Average of the column.
• COUNT (): Number of records.
• MAX(): Maximum of the column.
•MIN(): Minimum of the column.
• SUM(): Sum of the column.
Another arithmetic function is COUNT. This allows us to COUNT up the number of row in a certain table. The syntax is,
SELECT COUNT(“column_name”)
FROM “table_name“
SQL uses the MAX function to find the maximum value in a column. The syntax for using the MAX function is,
SELECT MAX(“column_name”)
FROM “table_name“
SQL uses the MIN function to find the maximum value in a column. The syntax for using the MIN function is,
SELECT MIN(“column_name”)
FROM “table_name”
The SUM function is used to calculate the total for a column. The syntax is,
SELECT SUM(“column_name”)
FROM “table_name“
SQL uses the AVG() function to calculate the average of a column. The syntax for using this function is,
SELECT AVG(“column_name”)
FROM “table_name”
Tech Snippets 