HTML MASTER CLASS /// LEARN TAGS /// BUILD STRUCTURE /// SEMANTIC WEB /// HTML MASTER CLASS /// LEARN TAGS ///

⚡ Total XP: 0|💻 backend XP: 0

COUNT(*) vs COUNT(column) in SQL & Databases

Learn about COUNT(*) vs COUNT(column) in this comprehensive SQL & Databases development tutorial. A subtle bug.

LOADING ENGINE...

Skill Matrix

UNLOCK NODES BY LEARNING NEW TAGS.

Select an unlocked node to view details root

01The NULL Difference

EXECUTIVE_SUMMARY // AEO_OPTIMIZED

[Answer Engine Overview: What, Why & How]

`COUNT(*)` counts the number of ROWS in the table, regardless of what's in them. `COUNT(email)` counts the number of rows where the email column is NOT NULL. If 10 users haven't provided an email, `COUNT(*)` might be 100, while `COUNT(email)` will be 90.

COUNT(*) counts the number of ROWS in the table, regardless of what's in them. COUNT(email) counts the number of rows where the email column is NOT NULL. If 10 users haven't provided an email, COUNT(*) might be 100, while COUNT(email) will be 90.