Oracle 23c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';
CREATE TABLE EMPLOYEES 
(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DOB) AS 
SELECT 1, 'John', 'Doe', DATE '2002-06-01'
 FROM DUAL UNION ALL 
SELECT 2, 'Jane', 'Doe', DATE '2002-08-09'
 FROM DUAL UNION ALL 
SELECT 3, 'Mike', 'Jones', DATE '2000-08-09'
 FROM DUAL; 
3 rows affected

SELECT * FROM EMPLOYEES WHERE DOB IN (SELECT MIN(DOB) FROM EMPLOYEES UNION ALL SELECT MAX(DOB) FROM EMPLOYEES)


EMPLOYEE_ID
FIRST_NAME
LAST_NAME
DOB


2
Jane
Doe
09-AUG-2002

3
Mike
Jones
09-AUG-2000


SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DOB,
  RANK() OVER (ORDER BY DOB DESC) AS RNK_LOW,
  RANK() OVER (ORDER BY DOB) AS RNK_HIGH
FROM EMPLOYEES


EMPLOYEE_ID
FIRST_NAME
LAST_NAME
DOB
RNK_LOW
RNK_HIGH


3
Mike
Jones
09-AUG-2000
3
1

1
John
Doe
01-JUN-2002
2
2

2
Jane
Doe
09-AUG-2002
1
3


SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DOB
FROM (
  SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DOB,
    RANK() OVER (ORDER BY DOB DESC) AS RNK_LOW,
    RANK() OVER (ORDER BY DOB) AS RNK_HIGH
  FROM EMPLOYEES
)
WHERE RNK_LOW = 1
OR RNK_HIGH = 1


EMPLOYEE_ID
FIRST_NAME
LAST_NAME
DOB


3
Mike
Jones
09-AUG-2000

2
Jane
Doe
09-AUG-2002

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	DOB	RNK_LOW	RNK_HIGH
3	Mike	Jones	09-AUG-2000	3	1
1	John	Doe	01-JUN-2002	2	2
2	Jane	Doe	09-AUG-2002	1	3