Find the difference
Sachin Ghatage

Sachin Ghatage @sachin_ghatage

About: Working in Tech Industry, love to share knowledge on tech

Location:
India
Joined:
Oct 6, 2025

Find the difference

Publish Date: Oct 14
3 0

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

Comments 0 total

    Add comment