sqlserver使用string_split统计分割数据行的数据

1.sqlserver 需要大于2016,如果提示：“string_split无效的对象名称”，说明不兼容

 --对应2016
alter database yourDb
SET COMPATIBILITY_LEVEL=130  

 --对应2017
alter database yourDb
SET COMPATIBILITY_LEVEL=140 

 --对应2019
alter database yourDb
SET COMPATIBILITY_LEVEL=150 

sql写法

-- where条件加上v.value!='',防止空数据
select v.value,count(v.value) EvaluateCount
From Service_Evaluate e join orders s on s.orderID = e.OrderID
CROSS APPLY STRING_SPLIT(e.MerchantQual, ',') v

where v.value!='' and s.ServiceISVID='19144' and e.MerchantrQualstar=5
group by v.value 
order by EvaluateCount desc

2.mysql

https://www.cnblogs.com/gered/p/11270188.html