SQL Server MCQs - CSE MCQs Questions and Answers

Home / CSE MCQs / SQL Server MCQs :: Discussion

With SQL, how can you return the number of not null records in the "Persons table ?

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

Answer : Option A

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.

Be The First To Comment

Comments

Name