This blog shows on the usage of NULL operator in the where condition, which doesnt pull all the empty columns or values with spaces. It will take the specified column which is unknown
Syntax:
Select *
From table
Where Column1 is NULL
Select EmpName
From Emptable
Where Empid is Numm