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
etc., etc.
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?