Sail E0 Webinar
Question
With SQL, how can you return the number of not null records in the "Persons table ?
Options:
A .  SELECT COUNT() FROM Persons
B .  SELECT COLUMNS() FROM Persons
C .  SELECT COLUMNS(*) FROM Persons
D .  SELECT COUNT(*) FROM Persons
Answer: Option A


COUNT(column_name) is used to count the number of rows of a table where column name is a column that does not allow NULL values.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers