select id,max(isnull(f1,'')),,max(isnull(f2,'')),max(isnull(f3,'')),max(isnull(f4,'')),...... from tb group by id
--> 测试数据: @Table declare @Table table (ID int,F1 varchar(1),F2 sql_variant,F3 sql_variant,F4 sql_variant) insert into @Table select 1,'A',null,null,null union all select 1,null,'B',null,null union all select 1,null,null,'C',null union all select 1,null,null,null,'D' union all select 2,'E',null,null,null union all select 2,null,'F',null,null select ID,f1=max(f1),f2=max(f2),f3=max(f3),f4=max(f4) from @Table group by id
select id,max(F1) as F1,max(F2) as F2,max(F3) as F3,max(F4) as F4 from [table] group by id
select ID,F1=max(F1),F2=max(F2),F3=max(F3)........ from table group by ID
from tb
group by id
--> 测试数据: @Table
declare @Table table (ID int,F1 varchar(1),F2 sql_variant,F3 sql_variant,F4 sql_variant)
insert into @Table
select 1,'A',null,null,null union all
select 1,null,'B',null,null union all
select 1,null,null,'C',null union all
select 1,null,null,null,'D' union all
select 2,'E',null,null,null union all
select 2,null,'F',null,null
select ID,f1=max(f1),f2=max(f2),f3=max(f3),f4=max(f4)
from @Table
group by id
from [table]
group by id
from
table
group by ID