Hello
I have a table with a lot of rows and every row has a timestamp:
machine1 / part1 / 01-01-2008
machine1 / part1 / 02-01-2008
machine1 / part1 / 03-01-2008
machine1 / part2 / 01-01-2008
machine1 / part2 / 04-01-2008
machine2 / part1 / 03-01-2008
machine2 / part1 / 02-01-2008
machine2 / part2 / 01-01-2008
and so on
Is there a way to get only the newest entry for every machine-part combination?
I hope this question is understandable.
Thank you.
Start Free Trial