SELECT id,[time] FROM(
SELECT id,[time],ROW_NUMBER()OVER(PARTITION BY id ORDER BY [time]DESC)RN FROM tabel
)T WHERE RN=1
SELECT id,[time],ROW_NUMBER()OVER(PARTITION BY id ORDER BY [time]DESC)RN FROM tabel
)T WHERE RN=1
GROUP BY Id