如何在单列中获得输出。 [英] How to get output in single column.

问题描述

CREATE TABLE address(
address1 varchar(15) NULL,
address2 varchar(15) NULL,
address3 varchar(15) NULL
) 
insert into address  
values (null, 'address2',Null)
insert into address 
values ('Address1', Null,Null)
insert into address 
values (Null, Null,'Address3')

如何获得输出

how to get output

Output
-------------
Address1
Address2
Address3
-------------

我的尝试：

What I have tried:

SELECT  address1,address2,address3   FROM address group by address1,address2,address3

推荐答案

select ISNULL(address1 , isnull(address2,(isnull(address3,'')))) from address Order by 1

试试

try

select COALESCE(address1,address2,address3) as Addres from address  order by Addres

参考SQL Server COALESCE（）函数 [ ^ ]

这篇关于如何在单列中获得输出。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！