MySQL 8.0

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

CREATE TABLE Measurements  (
  `id` INTEGER,
  `sensor_id` vaRCHAr(16),
  `value` FLOAT,
  `measured` varchar(14)
);

INSERT INTO Measurements 
  (`id`, `sensor_id`, `value`, `measured`)
VALUES
  ('22', '1000000000000001', '10.20', '1619166847821'),
  ('23', '0100000000000001', '67.00', '1619166847827'),
  ('24', '0000000000000001', '3.05', '1619166847830');

Records: 3  Duplicates: 0  Warnings: 0


SELECT t1.* 
FROM Measurements  t1 
INNER JOIN (SELECT MAX(id) max_id,`sensor_id` FROM Measurements  GROUP BY `sensor_id`) t2
ON t1.`sensor_id` = t2.`sensor_id` AND t1.id = t2.max_id


id
sensor_id
value
measured


22
1000000000000001
10.2
1619166847821

23
0100000000000001
67
1619166847827

24
0000000000000001
3.05
1619166847830

id	sensor_id	value	measured
22	1000000000000001	10.2	1619166847821
23	0100000000000001	67	1619166847827
24	0000000000000001	3.05	1619166847830