Re: [sqlite] How to get row numbers in a query?

[Jay Sprenkle]

> Because I need to insert them into the 2nd table as the result of a select,
> not first retrieve them all into my program, then loop over the results and
> insert into the 2nd table.

Sounds like a user defined function would be the way to go then.