why create another table, straightforward on 8.4:SELECT * FROM (SELECT *, (row_number() OVER( ORDER BY id))%10 AS rn FROMtable) sa WHERE sa.rn=1 LIMIT 10;