count(distinct case trainnumber when 'null' then 0 when '0' then 0 else trainnumber end) as train_num
sql case when 去重
最新推荐文章于 2024-06-12 10:08:37 发布
count(distinct case trainnumber when 'null' then 0 when '0' then 0 else trainnumber end) as train_num