Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - True or False (Q.No. 18)
18.
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
Discussion:
2 comments Page 1 of 1.
Ekta said:
7 years ago
Count() considers NULL values also. Please review the answer.
Nikhil said:
7 years ago
The Answer is correct.
COUNT function will only count the records where the expression is NOT NULL in COUNT (expression).
COUNT function will only count the records where the expression is NOT NULL in COUNT (expression).
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers