SQLite 3.27

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

create table numbers (
  num int
);
insert into numbers values (5),(6),(9),(10),(1),(15);
-- посмотрим порядок rowid
SELECT *, rowid
FROM numbers;


num
rowid


5
1

6
2

9
3

10
4

1
5

15
6


select rowid from numbers where num = 10;


rowid


4


delete from numbers where num = 10;
-- посмотрим не изменился ли порядок rowid
SELECT *, rowid
FROM numbers;


num
rowid


5
1

6
2

9
3

1
5

15
6


-- выбираем слудющую запись по rowid(10) + 1 -> 4+1
select num
  from numbers
  where rowid >= 5 -- 4+1
  order by rowid
  limit 1;


num


1