[Solved] Count the number of existing values in a field in a record [closed]
[ad_1] Use CASE expressions to count each column. SELECT CASE WHEN Column1 IS NOT NULL THEN 1 ELSE 0 END + CASE WHEN Column2 IS NOT NULL THEN 1 ELSE 0 END — repeat for all columns AS NumberOfNonNullColumns FROM MyTable 3 [ad_2] solved Count the number of existing values in a field in a … Read more