Select from following answers:- NULL values are ignored for all the aggregate functions
- NULL values are included for all the aggregate functions.
- When an aggregate function is included in the SELECT clause, all other expressions in the SELECT clause must either be aggregate functions or included in a GROUP BY clause.
- Both 1 and 3
- All Above
Aggregate functions perform a calculation on a set of values and return a single value. Except for COUNT, aggregate functions ignore null values. Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator