Adjacent Select

• Kushla

  SSC Enthusiast

  Points: 103

  More actions

  May 27, 2003 at 2:53 am

  #80985

  I want to return a specified column row with the adjacent number of

  rows above and below. e.g.

  Select *

  From Users

  Where ID = '7'

  It must return the 2 adjacent top and bottom rows. Is it possible?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 27, 2003 at 3:58 am

  #458600

  Please, do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12561&FORUM_ID=9&CAT_ID=1&Topic_Title=Select+statement&Forum_Title=General