SQLite 3.27

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

create table tuples
(
    a INTEGER not null,
    b INTEGER not null,
    c INTEGER not null,
    d INTEGER not null,
    primary key (a, b, c, d)
) without rowid;
insert into tuples values
(1,1,1,1),
(1,1,1,4),
(1,1,2,1),
(1,1,2,3),
(1,2,3,4);
SELECT *
FROM tuples
WHERE (1,1,1,3) < (a,b,c,d)
ORDER BY a,b,c,d LIMIT 1


a
b
c
d


1
1
1
4


SELECT *
FROM tuples
WHERE (1,1,2,2) < (a,b,c,d)
ORDER BY a,b,c,d LIMIT 1


a
b
c
d


1
1
2
3


SELECT *
FROM tuples
WHERE (1,1,2,4) < (a,b,c,d)
ORDER BY a,b,c,d LIMIT 1


a
b
c
d


1
2
3
4


SELECT *
FROM tuples
WHERE (1,2,4,2) < (a,b,c,d)
ORDER BY a,b,c,d LIMIT 1