Quick question, I'm sure this is simpler than i'm making it out to be.

So lets say I have a table with 3 columns 

```
colA   colB   colC
D      Adam   100
D      Dennis 200
D      Tim    300
C      Sharon 450
C      Cindy  400

```

How do I group by colA,take the max of colC and return the corresponding value for colB

e.g.

```
colA   colB    colC
D      Tim     300
C      Sharon  450

```

I hope that makes sense. Cheers guys!