I'm trying to construct a query that gives me the unique records based on a column. This is simplified sample of the data:

```
version        first            last
a              joe              smith
b              jane             smith
c              biff             mcelroy
a              thad             dussledorf

```

I'd like the query to return the unique records based on the `version` (so in this case 1 instance of a, b, and c). For these returned rows, all 3 columns should be represented. So the ideal result would be:

```
version        first            last
a              joe              smith
b              jane             smith
c              biff             mcelroy

```