没怎么看懂,看你是不是要这样的效果吧, 建立表 create table test(b1 varchar(10)) 插入数据 insert into dbo.test (b1) select 'a01' union all select 'b01' union all select 'a01' union all select 'b01' select*from test 查询 select b1,(case when b1='a01' then 'a01' else '' end... 20210311