SQL Command – Aggregate Functions

• 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“Continue reading “SQL Command – Aggregate Functions”