COUNT
| Expression | What It Counts | Nulls Included? | Use Case Example |
|---|---|---|---|
COUNT(*) | All rows in the result set | ✅ Yes | Total number of rows in a table or group |
COUNT(column) | Only rows where column is not null | ❌ No | Count of meaningful values in a column |
COUNT(*) is more expensive. |