Here be some data:

Notice that the first column has 3 dupes (117). The far right column is the UNIX stamp. What I need is the max() timestamp column of any duplicated row. This sample data was ran without the GROUP BY clause. If I use the GROUP BY clause the timestamp order is not correct.

So here is what I am after