This page discusses - Aggregate Functions in SQL, SQL Tutorial

Aggregate Functions

     

In this section we are going to illustrate aggregate function, with the help of which we can use many arithmetic operation like average, count, maximum and many more in SQL. They are briefly described and denoted by the keyword in the given below section.

AVG
COUNT
MAX
MIN
SUM

For all of the above given function the standard code syntax will be:

 

 

 

SELECT "function type" ("column_name") FROM "table_name"

For example we just take a Employee table and use the aggregate function SUM on the field "Salary" to find out the total salary of the Employee table.

Table Employee:

emp_Name	Salery	Joining_Date
Amit	15000	Feb-05-2005
Chandan	25000	Feb-17-2005
Ravi	8000	Feb-25-2005
Vinod	7000	Feb-28-2005

To find out the total salary of the company's employee we should write the following code:

SELECT SUM (Salary) FROM Employee;

When we run the above query we will get the following result:

SUM(Salary)

55000

Related Tags for Aggregate Functions in SQL, SQL Tutorial:

More Tutorials from this section

• Quartz Tutorial
• Advance (Enterprise) Features
• Aggregate Functions in SQL, SQL Tutorial
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Configuration, Resource Usage and StdSchedulerFactory
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create Database in SQL,SQL Tutorial
• Creating Cursors in SQL
• More About the CronTrigger
• Declare Cursors in SQL
• The DELETE Statement, SQL Tutorial