Skip to main content

Posts

Showing posts with the label SQL Aggregate

SQL Aggregate Functions

SQL Aggregate Functions (Image by - Sharma Guides | Subham232330) Aggregate Functions:- These functions are used to perform the calculations on data. -> Returns a single value. Types of SQL Aggregation Function      Aggregation Function          |          | - COUNT          |          | - SUM          |           | - AVG          |           | - MAX          |           | - MIN Count() = Return the number of rows. Sum() = It takes all values from different rows and returns their sum value. Avg() = This function accepts values from multiple rows and returns an average of all values. Max() = It returns the largest value. Min() = It returns the smallest value.