select case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end as b from a
pao1uo(冒牌游泳的鱼 V0.1)的对,但b字段有重复的
select b from( select case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end as b from a) T group by b
select T.b from (select case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end as b from a) T group by b
select case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end as b from a group by case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end
from a
from a) T
group by b
from (select case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end as b
from a) T
group by b
from a
group by case when charindex('|',b)>0 then left(b,charindex('|',b)-1) else b end