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 |