SQL Average

The built in SQL average function enable to you calculate the average values of a column. To the use the average function you would use the following syntax:

SYNTAX:

SELECT AVG("column_name")
FROM "table_name"

Table: Student

StudentID	LastName	FirstName	DOB	CourseFees	CourseName
1	John	Astone	07/15/1976	1000.00	Accountant
2	Bob	Eastwood	02/13/1935	1500.00	Economic
3	Jane	Hollywood	03/23/1939	2000.00	IT
4	Bob	Eastwood	03/19/1980	3000.00	Economic

Given the table above, if we want to get the average course fees for the four students we would issue the following statement:

SELECT AVG(CourseFees) AS 'AVG Course Fees'
FROM Student
 
RESULT:

AVG Course Fees

1875.00

Add New
Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email:

Website:

Comment:

Title:

UBBCode:

Message:

Security

Please input the anti-spam code that you can read in the image.

< Prev		Next >

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."