Hi! Could we please enable some services and cookies to improve your experience and our website?
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);