在一个列上选择DISTINCT，返回多个其他列(SQL Server)

I'm trying to write a query that returns the most recent GPS positions from a GPSReport table for each unique device. There are 50 devices in the table, so I only want 50 rows returned.I'm trying to write a query that returns the mo