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
-
Java Server Pages JavaServer Pages (JSP) technology is the Java platform technology for delivering dynamic content to web clients in a por...
-
In previous chapters, you learned to how to connect to SQL Server 2005 using management studio. In this chapter, you will learn how to creat... -
Defined data types (typedef) C++ allows the definition of our own types based on other existing data types. We can do this using the keyword... -
DIFFERENCE BETWEEN STRUCT AND UNION: In structures,each member has its own storage location,whereas all memebers of a union use the same loc...
-
Additional Form's Properties The Form has many of the Command Button's properties (MousePointer, BackColor, Visible and more). He al... -
# When the user submits form, his information is sent to the corresponding servlet file because we've set the ACTION attribute to point ...
-
Steps to follow: 1. Write Relation.java as shown in Code-11.5.a below. Please note that the Relation is an interface. (You are welcome to d...
No comments:
Post a Comment