用distinct去重或者用group分组,再用union联合
eg:
select NUMBER,name from TABLE where NUMBER != '' group by NUMBER
UNION ALL
select NUMBER,name from TABLE where NUMBER = ''