By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T (RankClass INT, NameLast VARCHAR(10));
INSERT INTO T (RankClass, NameLast)
VALUES
(NULL, 'Simth'),
(NULL, 'Jones'),
(1, 'Whatever'),
(2, 'Whatever'),
(3, 'Whatever'),
(4, 'Whatever'),
(5, 'Whatever');
Records: 7 Duplicates: 0 Warnings: 0
SELECT RankClass, NameLast
FROM T
ORDER BY -RankClass DESC, NameLast
| RankClass | NameLast |
|---|---|
| 1 | Whatever |
| 2 | Whatever |
| 3 | Whatever |
| 4 | Whatever |
| 5 | Whatever |
| null | Jones |
| null | Simth |