SQLite 3.27

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

CREATE TABLE t
AS
SELECT 'a' AS c UNION ALL
SELECT 'b' UNION ALL
SELECT 'c' UNION ALL
SELECT 'd' UNION ALL
SELECT 'e' UNION ALL
SELECT 'f' UNION ALL
SELECT 'g' UNION ALL
SELECT 'h' UNION ALL
SELECT 'i'
✓
SELECT * FROM t


c


a

b

c

d

e

f

g

h

i


WITH cte AS (
   SELECT *, ROW_NUMBER() OVER() AS rn
   FROM t
)
SELECT c 
FROM cte
WHERE rn IN (2,5)


c


b

e