Hi:

> The nice thing about using MIN and MAX is that:
> 1. The PK doesn't need to be continuous. It can skip values. (Like when
> deleting records)
> 2. It works with char fields as well as numeric so you can use it for
> almost anything.

So how do you set up the query to get the previous rec when current PK is 100 and
prev PK is 87?