The SQL AVG aggregate function selects the average value for certain table column.
Have a look at the SQL AVG syntax:
SELECT AVG(Column1)
FROM Table1
If we want to find out what is the average SaleAmount in the Sales table, we will use the following SQL AVG statement:
SELECT AVG(SaleAmount) AS AvgSaleAmount
FROM Sales
which will result in the following dataset:
AvgSaleAmount
$195.73
Popular Posts
-
Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
-
JSP pages are high level extension of servlet and it enable the developers to embed java code in html pages. JSP files are finally compiled ...
-
Preprocessor directives Preprocessor directives are lines included in the code of our programs that are not program statements but directive...
-
ADO .NET Most applications need data access at one point of time making it a crucial component when working with applications. Data access i... -
The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ... -
Getting Started (Continue) Look at the form with the title bar Form1. This is how your program will look like. Everything you will place on ... -
Advantages of MS Access MS Access is a light weight database managements system. Also, it provides it's own designer so that you can gen...
-
STRINGS: The way a group of integers can be stored in an integer array, similarly a group of characters can be stored in a character array. ...
-
ARRAYS: An array is a group of related data items that share a common name.For instance,we can define an array name salary to represent a se...
-
package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
No comments:
Post a Comment