Query to get latest log entries grouped by a field

Suppose you have logs with KEYWORDS [100, 101, 102] with same ID='new_id'.
Need to get the latest inserted record with all fields based on timestamp (say, 102 based on timestamp).
Equivalent to SQL: SELECT TOP 1, * FROM [TABLE_NAME] GROUP BY ID ORDER BY timestamp DESC