Select
Case
When a is not null then a
When b is not null then b
When c is not null then c
When d is not null then d
Else ''
End 列名
From Table Name
Select
Case
When a is not null then a
When b is not null then b
When c is not null then c
When d is not null then d
Else ''
End 列名
From Table Name