COUNT(*) vs COUNT(column_name) in SQL | Interview Question 🔥
🚀 SQL Interview Question
What is the difference between COUNT(*) and COUNT(column_name)?
✅ COUNT(*) counts all rows, including rows containing NULL values.
✅ COUNT(column_name) counts only non-NULL values in that column.
This is one of the most frequently asked SQL interview questions for Data Analysts, Data Engineers, and Database Developers.
#SQL #SQLInterviewQuestions #DataEngineering #PostgreSQL #MySQL #Database #LearnSQL #DataFuel