Computer Science
All aggregate functions except …………… ignore null values in their input collection.
- Count(attribute)
- Count(*)
- Avg
- Sum
SQL Joins & Grouping
1 Like
Answer
Count(*)
Reason — All aggregate functions, except for COUNT(*), ignore null values in their input collection. COUNT(*) returns all rows, including duplicates and nulls.
Answered By
1 Like
Related Questions
Which SQL function is used to count the number of rows in a SQL query ?
- COUNT()
- NUMBER()
- SUM()
- COUNT(*)
Which of the following is not an aggregate function ?
- Avg
- Sum
- With
- Min
Which of the following is a SQL aggregate function ?
- LEFT
- AVG
- JOIN
- LEN
Which of the following group functions ignore NULL values ?
- MAX
- COUNT
- SUM
- All of the above