I have a query that returns a result set similar to the one below
A | B | C | D
-----|----|----|-----
1 abc | d0 | e0 | true
2 def | d0 | e1 | true
3 ghi | d0 | e2 | true
4 jkl | d1 | e1 | true
5 mno | d2 | e2 | false
In Column A each value is unique. but column B,C,D have some duplicate values. I want all the values of Column A but distinct values of Column B,C,D.
Expected result is something like that
A | B | C | D
-----|---- |---- |-----
1 abc | d0 | e0 | true
2 def | NULL| e1 | NULL
3 ghi | NULL| NULL| NULL
4 jkl | d1 | NULL| NULL
5 mno | d2 | e2 | false
The only constraint is, I want to achieve this in a Single select statement. No nested Select statements.