select
b.PRIMARYPOLLUTANT,count(b.PRIMARYPOLLUTANT) as primarypollutantCount from (select PRIMARYPOLLUTANT=convert(xml,' <root> <v>'+replace(PRIMARYPOLLUTANT,',',' </v> <v>')+' </v> </root>') from AIR_BASE_DAY_AQI where AQI>='100' and TIMEPOINT>='2016-12-11' and TIMEPOINT<'2016-12-13')a outer apply (select PRIMARYPOLLUTANT=C.v.value('.','nvarchar(100)') from a.PRIMARYPOLLUTANT.nodes('/root/v')C(v))b group by b.PRIMARYPOLLUTANT
转载请注明原文地址: https://www.6miu.com/read-28053.html
