实习期间DBeaver用到的语句

查询最多字段不为空(非空列)的id行
select id ,
case when controlling_document !='' then 1 else 0 end +
case when environment !='' then 1 else 0 end +
-- case when escalated_to_tpl_counter !='' then 1 else 0 end +
-- case when escalated_to_upl_counter !='' then 1 else 0 end +
case when found_in_series !='' then 1 else 0 end +
case when found_in_sold_object !='' then 1 else 0 end +
-- case when gitcommitsreferenced !=''

实习期间DBeaver用到的语句最先出现在Python成神之路。