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 asc
fetch first 3 rows;