Specifies that AVG be performed only on each unique instance of a value, regardless of how many times the value occurs. expression Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.