27,579
社区成员
发帖
与我相关
我的任务
分享
Create table a1
(a int)
insert into a1(a)
select 26 union all
select 3 union all
select 5
select * from (select a,a as b from a1 ) a pivot (max(a) for b in ([26],[3],[5])) as pvt
--> 测试数据:[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([No1] int,[NO2] int,[NO3] int)
insert [TB]
select 26,null,null union all
select null,3,null union all
select null,null,5
select No1=max(isnull([No1],0)),
NO2=max(isnull([NO2],0)),
NO3=max(isnull([NO3],0))
from [TB]
/*
No1 NO2 NO3
----------- ----------- -----------
26 3 5
(1 行受影响)
*/
drop table [TB]
select max(No1) as No1,max(No2) as No2,max(No3) as No3 from table