On 3/9/18, Hegde, Deepakakumar (D.) <deep...@allgosystems.com> wrote: > > SELECT * FROM NEWFOLDER WHERE ID IN (3,1,2); >
Here is a query that gives the rows in the order you desire: WITH a(x,y) AS (VALUES(3,1),(1,2),(2,3)) SELECT newfolder.* FROM newfolder, a WHERE x=id ORDER BY y; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
