InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 02:06:59 GMT20http://www.sqlservercentral.com/Forums/Topic815847-338-1.aspxHi, 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[code="sql"]SELECT table1.column1, table2.column2FROM Sampletable as table 1 LEFT OUTER JOIN Sampletable as table2 ON table1.rownumber+1 = table2.rownumber[/code]Mon, 09 Nov 2009 09:34:11 GMTNick_UKhttp://www.sqlservercentral.com/Forums/Topic815847-338-1.aspxHi,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 1row3 with row2 and get the difference.Thanks for your help.DeminMon, 09 Nov 2009 08:56:34 GMTdemin99