Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
AVG « Aggregate Functions « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Aggregate Functions
AVG
9.2.AVG
9.2.1.
AVG calculates the average for selected records of numeric data in a column or the average for DISTINCT (unique) values of the selected records.
9.2.2.
Using DISTINCT in Aggregate Functions
9.2.3.
A summary query that uses the COUNT, AVG, and SUM functions
9.2.4.
adds the WHERE statement to calculate the average
9.2.5.
Selecting titles that sell more than the average.
9.2.6.
CAST(AVG(dec1) AS dec(5,2))