Report question

Question: SQL - find next and previous rows given a particular WHERE clause