sql pulling a row for next or previous row of a current row

Posted by basit. on Stack Overflow See other posts from Stack Overflow or by basit.
Published on 2009-08-11T10:06:17Z Indexed on 2010/05/13 14:34 UTC
Read the original article Hit count: 255

Filed under:
|
|
|
id    |  photo title     |  created_date

XEi43 |  my family       |  2009 08 04
dDls  |  friends group   |  2009 08 05
32kJ  |  beautiful place |  2009 08 06
EOIk  |  working late    |  2009 08 07 

Say I have the id 32kJ. How would I get the new or previous row?

© Stack Overflow or respective owner

Related posts about sql

Related posts about query