Easy learning with example program codes

how many types of aggregate functions are there in sql?

SQL Aggregate Functions are used to aggregate values from multiple columns in a table and returns a single value.

There are 7 aggregate functions available in SQL:

  • AVG(): It returns the average value from specified columns
  • COUNT(): It returns number of table rows
  • MAX(): It returns largest value among the records
  • MIN(): It returns smallest value among the records
  • SUM(): It returns the sum of specified column values
  • FIRST(): It returns the first value
  • LAST(): It returns last value

Related topics

Posted in SQL   

Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at


We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on

Copyright © 2019 CodesJava Protection Status SiteMap Reference: Java Wiki