How to select the latest entries of each ID?

Question

SQL

Hello, I have this request:

SELECT
  *
FROM Table_1
ORDER BY Id, DateUse DESC

Here is the result:

And you need to get only what is marked with arrows in the screenshot, please help.

Answer 1

SELECT *
FROM Table_1 t1
LEFT JOIN Table_1 t2 ON t2.id = t1.id AND t2.DateUse > t1.DateUse
WHERE t2.id IS NULL;

Answer 2

SELECT Table_Senture.* FROM Table_Senture
  INNER JOIN ( SELECT ID, MAX(DateUse) AS MaxDate FROM Table_Senture GROUP BY ID ) AS MR
    ON Table_Senture.ID = MR.ID AND DateUse = MaxDate