Get only one row if is not equals

i have my table:

ID | NAME | TYPE             
1  | A    | 1    
2  | A    | NULL  
3  | B    | NULL  
4  | C    | 2    
5  | D    | NULL 
6  | D    | NULL   

and i want to for example if i choose Type 1 i get the row but i want all the null values from the other.

ID | NAME | TYPE             
1  | A    | 1    
3  | B    | NULL  
5  | D    | NULL 
6  | D    | NULL   

sometime like this. i try with union but i get repeat A | NULL

thx for all

#sql #sql-server

4 Likes1.55 GEEK