PostgreSQL排序字段不唯一导致分页查询结果出现重复数据

create table test_select_order_page_duplicate
(
id varchar(36) not null
constraint test_select_order_page_duplicate_pk
primary key,
name varchar,
age integer
);

alter table test_select_order_page_duplicate owner to postgres;


insert
into test_select_order_page_duplicate
( id, name, age )
values
( '1111', 'aa', 12 ),
( '2222', 'aa', 12 ),
( '3333', 'aa', 12 ),
( '4444', 'aa', 12 ),
( '5555', 'aa', 13 ),
( '6666', 'aa', 12 ),
( '7777', 'aa', 12 ),
( '8888', 'aa', 13 ),
( '9999', 'aa', 12 ),
( '10101010', 'aa', 12 ),
( '11111111', 'aa', 14 ),
( '12121212', 'aa', 14 ),
( '13131313', 'aa', 12 );

select *
from
test_select_order_page_duplicate tsopd
order by
tsopd.age
limit 3;

select *
from
test_select_order_page_duplicate tsopd
order by
tsopd.age
limit 3 offset 3;

select *
from
test_select_order_page_duplicate tsopd
order by
tsopd.age, tsopd.id desc