query question

Giganews Newsgroups
Subject: query question
Posted by:  Karl Hungus (nnnnndddd…@hotmail.com)
Date: Thu, 01 Apr 2004

I would like to cycle through records (rows) one at a time in a table. My
primary key is not contiguous -- Im using a sequence to set it on insert.

whats the best way to structure the query to get a single record, and get
the primary key of the records before and after the current record? (eg.,
for prev/next buttons)