Paxdo wrote: > I need an equivalent to ROW_NUMBER. > > SELECT id, name FROM people ORDER BY name > > 12 Arthur > 23 Bill > 5 Chris > 34 Ron > 43 William > > The line number of the ID34 is 4. > But how to know with sqlite?
Count how often you have called sqlite3_step() on the statement. What do you need this number for? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users