I trying to right a query to calculate count. Lets say I have 4 columns M1, M2, M3 and Count.with 100 rows. I want a query to calculate number values available in each row and give me count of values in Count column, excluding missing values. Example: If row1 has values in M1, M2 and M3, Count will be 3. If in row 2 value of M2 is missing, count will be 2. Query should not be limited to number of rows, since data can sometimes have 100 rows or 1000.
... View more