With SQL, how can you return the number of not null records in the “Persons” table?
A. SELECT COUNT() FROM Persons
B. SELECT COLUMNS() FROM Persons
C. SELECT COLUMNS(*) FROM Persons
D. SELECT COUNT(*) FROM Persons
Answer:A
With SQL, how can you return the number of not null records in the “Persons” table?
A. SELECT COUNT() FROM Persons B. SELECT COLUMNS() FROM Persons C. SELECT COLUMNS(*) FROM Persons D. SELECT COUNT(*) FROM Persons
Explanation: 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.