MySQL 8.0

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

select version();


version()


8.0.27


CREATE TABLE patientInfo AS
SELECT 123456 AS patientID, 75 AS detailID, '01' AS value
UNION SELECT 123456, 	89, 	'12/01/2022'
UNION SELECT 123456,	151, 	'03'
UNION SELECT 123456, 	215, 	56813
SELECT * FROM patientInfo


patientID
detailID
value


123456
75
01

123456
89
12/01/2022

123456
151
03

123456
215
56813


SELECT patientId, value
FROM patientInfo
WHERE detailID IN (75, 151, 203)
ORDER BY detailID DESC
LIMIT 1


patientId
value


123456
03