in Databases retagged by
534 views
1 vote
1 vote

Name the SQL aggregation operator which does not ignore NULL. 

  1. COUNT
  2. MAX
  3. AVG
  4. SUM
in Databases retagged by
by
534 views

2 Answers

2 votes
2 votes
Count

Count(*) will give count of all rows(including null)

3 Comments

but count ignores null when a specific column contains null values right?

lets say

rno    name    marks
1       shas     99
2       pqrs      null
3       xyz       98

now if we apply, count(marks) it returns 2
0
0
0
0
0
0
2 votes
2 votes

Option a is right.

Related questions