By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH employee AS (
SELECT 'Rick' AS NAME, 3000 AS SALARY FROM dual UNION ALL
SELECT 'John', 4000 FROM dual UNION ALL
SELECT 'Shane', 3000 FROM dual UNION ALL
SELECT 'Peter', 5000 FROM dual UNION ALL
SELECT 'Jackob', 7000 FROM dual
),
cte AS (
SELECT NAME, SALARY,
RANK() OVER (ORDER BY SALARY) rnk_min,
RANK() OVER (ORDER BY SALARY DESC) rnk_max
FROM employee
)
SELECT NAME, SALARY
FROM cte
WHERE rnk_min = 1 OR rnk_max = 1
ORDER BY SALARY;
| NAME | SALARY |
|---|---|
| Rick | 3000 |
| Shane | 3000 |
| Jackob | 7000 |