All aggregate functions except _____ ignore null values in their input collection. Options: A . &nbspCount(attribute) B . &nbspCount(*) C . &nbspAvg D . &nbspSum

All aggregate functions except _____ ignore null values in their input collecti

Question - All aggregate functions except _____ ignore null values in their input collection.

Options:

A . Count(attribute)

B . Count(*)

C . Avg

D . Sum

Answer: Option B

Count(*)* is used to select all values including null.

Was this answer helpful ?

Next Question