SQLite 3.27

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

Create Table Part(Part TEXT, Rev TEXT, DateCode Date, Unique(Part,Rev));
✓
INSERT INTO Part VALUES
('PART_1', 'B', '2022-02-14'),
('PART_1', 'A', '1999-01-11'),
('PART_2', 'C', '2000-02-24'),
('PART_2', 'B', '1998-11-12'),
('PART_2', 'A', '1998-11-10');
✓
SELECT *
FROM Part
ORDER BY MAX(DateCode) OVER (PARTITION BY Part) DESC,
         Part, -- just in case 2 different parts have the same max DateCode
         DateCode DESC;


Part
Rev
DateCode


PART_1
B
2022-02-14

PART_1
A
1999-01-11

PART_2
C
2000-02-24

PART_2
B
1998-11-12

PART_2
A
1998-11-10

Part	Rev	DateCode
PART_1	B	2022-02-14
PART_1	A	1999-01-11
PART_2	C	2000-02-24
PART_2	B	1998-11-12
PART_2	A	1998-11-10