WITH n(n) AS ( SELECT COUNT(*) FROM my_table ) ,
a(id, other_cols, m) AS
( SELECT id, other_cols,
ROW_NUMBER() OVER (ORDER BY id DESC)
FROM my_table
)
SELECT id, other_cols
FROM a, n
WHERE m * 10 <= n
ORDER BY id