SQL:如何从具有字符串值的列中查找特定类别值的计数

如果您试图获得用逗号分隔的Category Ids，可以使用string_split函数获得不同的category_id

with cte as (
    select 1 as id, '3,2' as category union all
    select 2, '1' union all
    select 3, '4,3,2' union all
    select 4, '2,1' union all
    select 5, '1,4' union all
    select 6, '2,3,4' 
)select count(distinct(value)) as category from cte
cross apply string_split(cte.category, ',');