Wed Apr 13 2022 06:26:59 GMT+0000 (Coordinated Universal Time)
Saved by @Bambibo9799
--- using sum case when to find the percentage of null value select sum(case when no is null then 1 else 0 end) / Sum(1.00) as nullpercentage, sum(case when no = 'jason' then 1 else 0 end) / Sum(1.00) as notnullpercentage from zzzzzz_csv as zc
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments