This is still a bit tricky, but I have another work-around for my problem and all sorted now.
RBS On Sun, Dec 11, 2016 at 10:02 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Dec 2016, at 9:55pm, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > >> where rowid = (select min(rowid) from table1) > > > > Yes, that is also what I came up with but this is a bit tricky to add in > > code if there is where clause already > > (or even multiple where clauses when there are table joins) and I thought > > there might be some better method. > > Add to the end > > ORDER BY rowid LIMIT 1 > > if you already have an ORDER BY clause, add after it > > ,rowid LIMIT 1 > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
