Goal : Count the data in each column
Input :
| col1 | col2 | col3 |
| a | {NULL} | b |
| f | k | {NULL} |
| h | {NULL} | n |
| i | d | {NULL} |
| {NULL} | s | {NULL} |
| g | u | m |
| l | x | o |
| m | {NULL} | {NULL} |
| c | d | z |
Output :
Count_Rows Count_col1
Count_col2 Count_col3
9 8
6 5
No comments :
Post a Comment