sqlserver 两列合并去除重复项

create database  testdata;
use testdata;
create table test( a varchar(10) ,b varchar(10) ,c varchar(10) ,d varchar(10))
insert into test values('1','3','1','3')
insert into test values('2','2','6','4')
insert into test (a,b) values('4','1')
insert into test (a,b) values('3','2')
select * from test;

 

select (case when a=c then a else isnull(c,a) end) e,isnull(b,'') f,isnull(d,'') g from test order by e