So I am trying to pull rows from a table where there are more than one version for an ID that has at least one person for the ID that is not null but the versions that come after it are null.

So, if i had a statement like:

```
select ID, version, person from table1

```

the output would be:

```
ID  Version  Person
--  -------  ------
 1        1  Tom 
 1        2  null 
 1        3  null   
 2        1  null
 2        2  null   
 2        3  null
 3        1  Mary
 3        2  Mary
 4        1  Joseph
 4        2  null   
 4        3  Samantha

```

The version number can have an infinite value and is not limited.

I want to pull ID 1 version 2/3, and ID 4 Version 2.

So in the case of ID 2 where the person is null for all three rows I don't need these rows. And in the case of ID 3 version 1 and 2 I don't need these rows because there is never a null value.

This is a very simple version of the table I am working with but the "real" table is a lot more complicated with a bunch of joins already in it.

The desired output would be:

```
ID     Version     Person
--     -------     ------
1        2           null
1        3           null    
4        2           null

```

The result set that I am looking for is where in a previous version for the same ID there was a person listed but is now null.