Hey guys. I wish to get the "next" record of a certain type, such that if we have row Id x, then:
Select the minimum id such that id > x (with some WHERE conditions) If there is no such id (ie x is the largest with the conditions) then the first id with those conditions is returned. I'm doing this with logic in code at the moment, but am curious whether there is an SQLite method for it. Thanks, Ian _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
