4 Replies Latest reply: Aug 25, 2011 5:37 AM by Stefan Wühl RSS

    How to find previous and next record from a table?

      Hi....

      Suppose I have a tbale with dates..

       

       

      Date
      01/01/2011
      01/01/2011
      01/01/2011
      5/05/2011
      8/8/2011
      8/8/2011
      10/10/2011

       

      I want a table with following columns...

       

       

      DatePrevious DateNext Date
      01/01/2011-01/01/2011
      01/01/201101/01/201101/01/2011
      01/01/201101/01/20115/01/2011
      5/05/201101/01/20118/8/2011
      8/8/20115/05/20118/8/2011
      8/8/20118/8/201110/10/2011
      10/10/20118/8/2011-

       

      I want Previous and next record of each rows.

       

      Thanks in advance...

       

      Satish