By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.13 |
CREATE TABLE metric_history (
`id` INTEGER,
`mId` INTEGER,
`value` VARCHAR(5),
`recordCreated` VARCHAR(19)
);
INSERT INTO metric_history
(`id`, `mId`, `value`, `recordCreated`)
VALUES
('1', '1', 'lorem', '2019-02-06 15:19:33'),
('2', '1', 'ipsum', '2019-02-06 15:19:43'),
('3', '2', 'at', '2019-02-06 15:37:48'),
('4', '1', 'dolor', '2019-02-06 15:41:31'),
('5', '2', 'vero', '2019-02-06 15:42:02'),
('6', '1', 'sit', '2019-02-06 15:47:15'),
('7', '2', 'eos', '2019-02-06 15:49:11'),
('8', '1', 'amet', '2019-02-06 15:50:59'),
('9', '4', 'sed', '2019-02-06 15:54:09');
SELECT id, mId, value, recordCreated
FROM (
SELECT
id, mId, value, recordCreated,
ROW_NUMBER() OVER (PARTITION BY mId ORDER BY recordCreated DESC) AS `rank`
FROM metric_history
ORDER BY id
) AS tmp
WHERE tmp.`rank` = 1
| id | mId | value | recordCreated |
|---|---|---|---|
| 7 | 2 | eos | 2019-02-06 15:49:11 |
| 8 | 1 | amet | 2019-02-06 15:50:59 |
| 9 | 4 | sed | 2019-02-06 15:54:09 |