Wednesday, 23 November 2011


The SQL AVG() aggregate function allows us to Average of the Total numeric value for a certain column.

SQL AVG() Syntax

The SQL AVG() function syntax is very simple and it looks like this
SELECT AVG(column_name) FROM table_name

SQL AVG() Example

We have following "Table_1" name table:

S_NoS_NameTotalPercentage
1Jay50777.84
2Ajay48774.92
3Bhavesh46972.15
4Jaimin46371.23
5Dolar42565.38

Example Statement:
SQL> SELECT AVG(Total) AS Average_Total FROM Table_1;
Example Result will look like This:

Average_Total
470








SQL GUIDE

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers