With SQL, how can you return the number of not null records in the Pe – McqOptions

MCQOPTIONS

1.	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» B. SELECT COLUMNS() FROM Persons

Discussion

No Comment Found

Related MCQs

How can you change Hansen into Nilsen in the LastName column in the Persons table?
With SQL, how can you return the number of not null records in the Persons table?
With SQL, how can you return all the records from a table named Persons sorted descending by FirstName ?
With SQL, how do you select all the records from a table named Persons where the value of the column FirstName ends with an a ?