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