I have a table with following record.
ParentID Value
1 NULL
1 NULL
2 3
2 NULL
3 4
3 10
How to write a query to get records with same parentID and at least one value is NULL and NON Null..
For example, returned record should be
ParentID Value
2 3
2 NULL