Table of Contents

Search

  1. About the Data Vault SQL Reference
  2. Introduction to SQL Reference for Informatica Data Vault
  3. Date and Time Arithmetic
  4. WHERE Clauses
  5. UNION Operator
  6. Parameterized Query
  7. Functions

Data Vault SQL Reference

Data Vault SQL Reference

AVG

AVG

An aggregate function that returns the average of the non-null values in the specified or derived column (numeric data only).

AVG Syntax

AVG (value-expression) AVG (DISTINCT value-expression)

0 COMMENTS

We’d like to hear from you!