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
-
Introduction: In this exercise, you are going to build and run a sample Java program called CommandLineusing NetBeans. The sample program c... -
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. ...
-
More About Ascii How can I know what is the Ascii value of a specific character? Use the Asc command. For example, the following line: Print...
-
*Servlets are Java programs running on a web server that produce results viewed remotely on web server. *Servlets has the same purpos...
-
CONTROL STRUCTURES: Three types of control structures: 1.Decision control structure : if,if else,nested if etc 2.Loop control structure ...
-
MSDE stands for Microsoft Desktop Engine. MSDE is replaced with Microsoft SQL Server 2005 Express. MSDE is a free, light weight version of S...
-
SQL Server Express is a free, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications....
-
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>Using JavaServer Pages... -
The SQL ORDER BY clause comes in handy when you want to sort your SQL result sets by some column(s). For example if you want to select all t...
-
Using functions we can structure our programs in a more modular way, accessing all the potential that structured programming can offer to us...
No comments:
Post a Comment