Morning,
Currently working on a cleansing phase of a dB project. It's required remove row from a table where the entire row is NULL.
Example :
COL1 COL2 COL3
1 A1 B1 C1
2 A2 B2 NULL
3 NULL B3 C3
4 NULL NULL NULL
5 A5 B5 C5
6 NULL NULL NULL
7 A7 NULL NULL
8 A8 B8 NULL
9 NULL B9 C9
10 A10 B10 C10
As you can see, the enrire ROW4 and ROW6 is NULL. This is the type of row that needs to be remove.
There are 1728635 rows in this table.
Is there ways where :
We able to identify which rows have it's entire data NULL
and
Removing all rows that the entire data is NULL