求SQL查询语句怎么写

select id,group_concat(值) from tablename group by id
要是oracle那就是wm_concat()

只能做到这样了。

select id,
case when shuzhi='1' then 1 when shuzhi like '1,%' then 1
when shuzhi like '%,1' then 1 when charindex(',1,',shuzhi)>0 then 1
else null end as shuzhi1,
case when shuzhi='2' then 2 when shuzhi like '2,%' then 2
when shuzhi like '%,2' then 2 when charindex(',2,',shuzhi)>0 then 2
else null end as shuzhi2,
case when shuzhi='3' then 3 when shuzhi like '3,%' then 3
when shuzhi like '%,3' then 1 when charindex(',3,',shuzhi)>0 then 3
else null end as shuzhi3,
case when shuzhi='4' then 4 when shuzhi like '4,%' then 4
when shuzhi like '%,4' then 4 when charindex(',4,',shuzhi)>0 then 4
else null end as shuzhi4,
case when shuzhi='5' then 5 when shuzhi like '5,%' then 5
when shuzhi like '%,5' then 5 when charindex(',5,',shuzhi)>0 then 5
else null end as shuzhi5,
case when shuzhi='6' then 6 when shuzhi like '6,%' then 6
when shuzhi like '%,6' then 6 when charindex(',6,',shuzhi)>0 then 6
else null end as shuzhi6
from tableName;