SQLize Online / PHPize Online  /  SQLtest Online

Share      Blog   Popular
Copy Format Clear
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 rank() over (partition by id, name order by salary desc) fetch first 1 rows with ties;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear