Hi! Supose i have a table like this: Table ----- X Y Z 1|1|1 1|2|2 1|3|3 2|1|2 2|2|4 2|3|6 3|1|3 3|2|6 3|3|9
As far as i know there isn't a SQL statment to get next result in sqlite: Result ------- M|1|2|3 1|1|2|3 2|2|4|6 3|3|6|9
I think the best approach is create a temporary table, so i can use it in Select clauses (ie. Select * from Result where M = 2 : 2|2|4|6 ).
Am i right?
Are there future plans of include some XSelect statment to bring such feature without creating temporary tables by hand?
Thank you in advance! Marcelo
