有一个关于sql的问题需要解决

[顾君彦]

表结构和数据如下：
ID Name1 Name2
1 N1 NULL
2 N2 NULL
3 NULL N3
4 N4 NULL

我想最终显示的时候仍然是
1 N1
2 N2
3 N3
4 N4
请问这样的SQL语句该如何写？

[水族杰纶]

select id,isnull(name1,name2) from tb

[liangCK]

SELECT
    ID,
    ISNULL(Name1,Name2) AS Name
FROM tb

[水族杰纶]

--不是问过?现在问题是?
if object_id('tb')is not null drop table tb
go
create table tb(ID int,  Name1 varchar(10),  Name2 varchar(10)) 
insert tb select 1, 'N1',  NULL 
insert tb select 2,    'N2' ,     NULL 
insert tb select 3,    NULL  ,  'N3' 
insert tb select 4,    'N4'   ,   NULL 
select id,isnull(name1,name2)[name] from tb
/*id          name
----------- ----------
1           N1
2           N2
3           N3
4           N4*/

[编程宝库]

SQL codeif object_id('tempdb..#')is not null drop table #
go
create table #(ID int, Name1 varchar(10), Name2 varchar(10))
insert # select 1 ,'N1' ,NULL
insert # select 2 , 'N2' , NULL
insert # select 3 , NULL , 'N3'
insert # select 4, 'N4', NULL
select id,[name] from (
select id,name1 [Name] from #
union all
select id,name2 from #)T
where [name]is not null
/*id name
----------- ----------
1 N1
2 N2
4 N4
3 N3*/

[lihan6415151528]

select id,isnull(name1,name2)[name] from tb

[luckyleaf521]

SELECT ID,CASE WHEN NAME1 IS NULL THEN NAME2 ELSE NAME1 END AS [NAME] FROM TB

[zoujp_xyz]

select id,isnull(name1,name2) from tb