MySQL 8.0

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

CREATE TABLE user (
    id int,
    name varchar(255)
);
insert into user values (1, 'a'), (2, 'b'), (3, 'c');

Records: 3  Duplicates: 0  Warnings: 0

select id from user where id >= 2 order by id limit 1;

id

2

select * from user where id IN(
  select id from user where id >= 1 limit 1
);

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

select * from user where id IN(
  select id from user where id >= 1 order by id limit 1
);

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

select * from user where id IN(
  select * from (select id from user where id >= 1 order by id limit 1) t
);

id
name

1
a