SQLite 3.27

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

create table table1 (
  id integer,
  name text);
✓
insert into table1
values
(1,'M'),
(2,'P'),
(3,'A1'),
(4,'C'),
(5,'A2'),
(6,'T'),
(1009,'A2'),
(1011,'A1'),
(1010,'A3');
✓
SELECT *
FROM table1
ORDER BY
  CASE WHEN Id < 1000 THEN Id ELSE 1000 END,
  Name;


id
name


1
M

2
P

3
A1

4
C

5
A2

6
T

1011
A1

1009
A2

1010
A3


SELECT *
FROM (
  SELECT Id, Name, LEAD(Id) OVER w AS Next_Id, LEAD(Name) OVER w AS Next_Name
  FROM table1
  WINDOW w AS (ORDER BY CASE WHEN Id < 1000 THEN Id ELSE 1000 END, Name)
) WHERE Id = 6;


Id
Name
Next_Id
Next_Name


6
T
1011
A1