SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  Date DATE,
  ID VARCHAR(1),
  Qty INT
);
INSERT INTO test VALUES
  ('2019-05-01', 'A', 11),
  ('2019-06-01', 'A', 22),
  ('2019-07-01', 'B', 33),
  ('2019-06-01', 'B', 44);
4 rows affected

SELECT t.* 
FROM test t INNER JOIN (
    SELECT MAX(Date) AS Date, ID 
    FROM test
    GROUP BY ID
) tMAX ON t.ID = tMAX.ID AND t.Date = tMAX.Date


Date
ID
Qty


01/07/2019 00:00:00
B
33

01/06/2019 00:00:00
A
22