The Gateway to Computer Science Excellence
0 votes
138 views

Name the SQL aggregation operator which does not ignore NULL. 

  1. COUNT
  2. MAX
  3. AVG
  4. SUM
in Revision by Veteran (424k points)
retagged by | 138 views

2 Answers

+2 votes
Count

Count(*) will give count of all rows(including null)
by Boss (31.2k points)
0
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 votes

Option a is right.

by Boss (35.6k points)

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,479 answers
195,421 comments
100,557 users