Computer Science
All aggregate functions except …………… ignore null values in their input collection.
- Count(attribute)
- Count(*)
- Avg
- Sum
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