Hello all, I'm not sure if this can be done in SQL, but if it can, I'd appreciate your help.
Let's say I've got this query: SELECT * FROM (SELECT * FROM Data WHERE PlotOnGraph=1 ORDER BY Date ASC) LIMIT ?2 OFFSET ?1 and let's say, "Data" has an "ID" field (primary index). Is it possible to find out the *position* in the returned result set of a Data with a given ID? So, let's say the returned result was (just IDs): 1 2 3 4 5 6 9 7 11 14 12 13 10 Can I find out that ID=9 is number 7 (or 6 if zero-based, doesn't matter) using only SQL? Thanks in advance! Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
