create table employees (id serial, name text, salary int);
insert into employees (name, salary) values
('John', 5500),
('Kate', 7200),
('Roy', 3900),
('Bill', 7200);
select *
from employees
where salary = (select max(salary) from employees);
select *
from employees
order by salary desc
fetch first 1 rows with ties;