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

M

Mr. Dubey

🎓 Coach ⭐ 103.11K Points

📊 Database Management System (DBMS)

Q. 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

💬 Discuss

✅ Correct Answer: (A) SELECT COUNT() FROM Persons

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

906

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

95%

Success Rate