How to select columns with null values
649638Feb 5 2009 — edited Dec 16 2009HI
In my table ‘A’ I have 10 columns and 30,000 records. I need all those columns whose value is null for all the records.
For example in the below table column 'suffix' is null for all the records. So I want column suffix to be selected.
Name Suffix Street
James 1100 Washington street
Richard 273 GEORGIA ST
Arnold 3018 OAKHILL AVE
MICHAEL 834 E 161ST ST
Joseph 410 PINE AVE
Thanks in advance