Cacher is the code snippet organizer for pro developers

-- How get value in previous row and value in next row?
SELECT * FROM Example
WHERE id IN (
  (SELECT MIN(id) FROM Example WHERE id > 3), (SELECT MAX(id) FROM Example WHERE id < 3)
)

-- http://stackoverflow.com/questions/20849098/mysql-how-get-value-in-previous-row-and-value-in-next-row