Computer Science
Which of the following group functions ignore NULL values ?
- MAX
- COUNT
- SUM
- All of the above
SQL Joins & Grouping
1 Like
Answer
All of the above
Reason — All aggregate functions, except for COUNT(*), ignore null values in their input collection.
Answered By
1 Like
Related Questions
All aggregate functions except …………… ignore null values in their input collection.
- Count(attribute)
- Count(*)
- Avg
- Sum
Which of the following is a SQL aggregate function ?
- LEFT
- AVG
- JOIN
- LEN
The functions which work with individual rows' data are called …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these
Function count() is a/an …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these