if OBJECT_ID('tb') is not nulldrop table tbgocreate table tb(a varchar(50), b varchar(50))insert into tb values('1',null)insert into tb values('2','3')insert into tb values('3',null)insert into tb values('4','3')insert into tb values('5','1')select * from tb/*a
...