On 3/9/18, Hegde, Deepakakumar (D.) <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
