Deleting Records with Null values
I have this table that has 120 records total. There are 5 records in COLUMN-A that have Null value (blank). But, when I did count(*) on this table where COLUMN-A is null - I still get 120 records back, I expected to see 115 records because there are 5 records with a null value.
Here is a sample of this basic query:
select count(*) from MYTABLE
WHERE COLUMN-A is null;
Thank you.
A.J.