Hello, I have a problem and I do not find the solution with Sqlite. I need an equivalent to ROW_NUMBER.
Here's the problem: SELECT id, name FROM people ORDER BY name On this, I would like to know the line number of the ID 34, how? example: SELECT id, name FROM people ORDER BY name Result: 12 Arthur 23 Bill 5 Chris 34 Ron 43 William The line number of the ID34 is 4. But how to know with sqlite? Thank you very much! Olivier _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
