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