title: How to get the prev and next row of target row
body: <p>For example data like this</p>
  
  <pre><code>ID  name
  8   apple 
  13  lemon
  15  melon
  16  banana
  18  watermelon
  19  peanuts
  20  orange
  24  hamburger
  25  maron
  </code></pre>
  
  <p>I got the banana by ID.</p>
  
  <pre><code>Select id,name where id = 16
  </code></pre>
  
  <p>However I would like to get the prev and next row as well.</p>
  
  <p>In this case.</p>
  
  <p>I would like to get
  15 melon and 18 watermelon</p>
  
  <p>What is the best practice for this purpose??</p>