Member since
11-04-2022
1
Post
0
Kudos Received
0
Solutions
11-11-2022
02:59 AM
@Shawn Here is a small example on how to find out what's the percentage of NOT NULL value of column maker: select ((tot_cnt - a.null_maker)/tot_cnt)*100 as pcnt_not_null_maker
from
(select count(maker) as null_maker from used_cars where maker is NULL) a
Left outer join
(select count(*) as tot_cnt from used_cars) b You may try this for all individual columns.
... View more