add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE foo (`ID` INTEGER, `Size` INTEGER);

INSERT INTO foo (`ID`, `Size`) VALUES
('0', '3'),
('1', '8'),
('2', '3'),
('3', '3'),
('4', '10'),
('5', '7');
Records: 6  Duplicates: 0  Warnings: 0
WITH cte AS (SELECT *, ROW_NUMBER() OVER (ORDER BY Size, ID) rn FROM foo)
SELECT ID, Size
FROM cte
WHERE rn > (SELECT rn FROM cte WHERE ID = 2)
ORDER BY rn LIMIT 3;
ID Size
3 3
5 7
1 8