1)SELECT COUNT(*) FROM Employee;
2)SELECT COUNT(ManagerId) FROM Employee;
First statement counts all the records including nulls
Second statement counts only non null records
Difference is small but very much important


About: Working in Tech Industry, love to share knowledge on tech
1)SELECT COUNT(*) FROM Employee;
2)SELECT COUNT(ManagerId) FROM Employee;
First statement counts all the records including nulls
Second statement counts only non null records
Difference is small but very much important