ID ------------ 1 2 3 4 11 12 13 14If we have the 14 (we know to start at 14) can we select the records 14, 13, 12 and 11, so the consecutive numbers, going down from 14?
Sure:select id from yourtable where id <= 14 limit 4 order by id desc;
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users