New posts in Insert Select

SQLITE equivalent for Oracle's ROWNUM?

INSERT with SELECT