COUNT(*) versus COUNT(column)
QuizEasy-Medium
The orders table has 10 rows. One order has a NULL amount. What do COUNT(*) and COUNT(amount) return?
- COUNT(*) is 10 and COUNT(amount) is 9
- Both are 10
- Both are 9
- COUNT(amount) counts the different amounts
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.