filter our all-na columns in sql code example Example: filter only NA column in R subset(data,is.na(ColWtCL_6))