databasessql
Count star and count column answer different questions
Anonymous
In SQL, COUNT(*) counts rows, while COUNT(column_name) counts only rows where that column is not NULL. In a grouped query, that difference applies within each group. Check which quantity the question asks for before choosing the expression.
0