On 6 Aug 2017, at 9:03pm, Edmondo Borasio <edmondobora...@gmail.com> wrote:
> *progr_no* *ID* > 1 grace > *2* *john* > 3 alan > 4 tim > *5* *john* > *6* *john* > 7 sandra > *8* *john* > > What is the simplest and most efficient way of telling SQLITE to select the > NEXT or the PREVIOUS *progr_no *for a given recurring ID, let's say "john"? Trying to understand this. Are you saying that you start knowing "john" and want the program to produce NEXT = 6 ? How should the program know which "john" you’re currently on ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
