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
