By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employees
("DEPARTMENT_ID" int, "LAST_NAME" varchar2(10), "EMPLOYEE_ID" int)
;
INSERT ALL
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (10, 'Whalen', 200)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (20, 'Hartstein', 201)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (20, 'Fay', 202)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Raphaely', 114)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Khoo', 115)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Baida', 116)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Tobias', 117)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Himuro', 118)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (30, 'Colmenares', 119)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (40, 'Mavris', 203)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (100, 'Popp', 113)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (110, 'Higgins', 205)
INTO employees ("DEPARTMENT_ID", "LAST_NAME", "EMPLOYEE_ID")
VALUES (110, 'Gietz', 206)
SELECT * FROM dual
;
13 rows affected
SELECT t.department_id, t.last_name, t.employee_id
FROM (
SELECT department_id, last_name, employee_id,
ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY employee_id DESC) rn
FROM employees
) t
WHERE t.rn = 1
| DEPARTMENT_ID | LAST_NAME | EMPLOYEE_ID |
|---|---|---|
| 10 | Whalen | 200 |
| 20 | Fay | 202 |
| 30 | Colmenares | 119 |
| 40 | Mavris | 203 |
| 100 | Popp | 113 |
| 110 | Gietz | 206 |