Two implementations:
CREATE TABLE t (a int, b int);
INSERT INTO t VALUES(1,1);
INSERT INTO t VALUES(2,4);
INSERT INTO t VALUES(3,9);
INSERT INTO t VALUES(4,16);
INSERT INTO t VALUES(5,25);
INSERT INTO t VALUES(6,36);
INSERT INTO t VALUES(7,49);
INSERT INTO t VALUES(8,64);
INSERT INTO t VALUES(9,81
On 15 Jun 2011, at 9:20pm, Michael Stephenson wrote:
> Wondering if anyone has a way to execute a query that selects rows based on
> a list of rowids and returns the results in the order of the rowids passed
> in.
Make another table with the rowids in, and use a JOIN.
Simon.
___
Wondering if anyone has a way to execute a query that selects rows based on
a list of rowids and returns the results in the order of the rowids passed
in.
Thanks,
~Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
3 matches
Mail list logo