I have a table like so;
Component | Time 1 | 2014-03-13 13:52:12 1 | 2013-05-20 12:20:20 2 | 2014-03-13 13:53:43
There can be x times for a single component. i.e. Component 1 has 2 times, Component 2 has 1 time, Component 3 might have 5 times.
I can used the Group function to group by component, what I really want though, is to just have the most recent time for each component. Not sure if there's a function to do something like this? Or I'll need to make something myself?