Compare rows in tables

• demin99

  SSC Eights!

  Points: 927

  More actions

  November 9, 2009 at 8:56 am

  #156389

  Hi,

  I need to compare concecutive records in a single table and find the difference of 1 column .

  Iam grouping with rownumber ,but how do I compare the row 2 with row 1

  row3 with row2 and get the difference.

  Thanks for your help.

  Demin

• Nick_UK

  SSCommitted

  Points: 1909

  More actions

  November 9, 2009 at 9:34 am

  #1076729

  Hi,

  if you have the row number for the table already you could join this table in on itself as below allow you to join one row to the next

  SELECTtable1.column1,

  table2.column2

  FROM Sampletable as table 1

  LEFT OUTER JOIN Sampletable as table2

  ON table1.rownumber+1 = table2.rownumber