I'm trying to find the first row before and the first row after a specific
row.  Essentially I want to do these two queries, and get each row.

SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId DESC LIMIT 1;
SELECT * FROM Users WHERE UserId = <userId> ORDER BY UserId LIMIT 1;

Is there any way to combine this into one query?  OFFSET doesn't allow a
negative number, which is essentially what I want.

Thanks,
Waynn

Reply via email to