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 |