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.