> 2. The above statement gets the lowest rowid but there appears to be > no > implicit statement to the direction of the ORDER BY clause. Can the > statement be reversed to get the highest rowid?
> SELECT ... FROM <table> ORDER BY rowid DESC LIMIT 1; Okay, I feel very stupid now, hadn't twigged. I was typing in DESCENDING rather than DESC and didn't know why it was failing (LOL) I think I will go to bed now. -- View this message in context: http://www.nabble.com/Fetch-first-non-sequential-record-tp21125757p21126513.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users