Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 13.23 (Debian 13.23-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit

SELECT 1

create table score (name text, points int);
insert into score values ('ann',10),('bob',10),('cat',7),('dan',5);

CREATE TABLE

INSERT 0 4

-- WITH TIES arrived in PostgreSQL 13: ann and bob both stay
select * from score
order by points desc
fetch first 1 row with ties;

name
points

ann
10

bob
10

SELECT 2