Hello Team,
I am closing this case, as I have got solution for it.
=======================================================
<pre lang="sql">
CREATE PROCEDURE GetDiffView()
BEGIN
SET @isFirstRow=1;
SET @ColumnThreeValuePrevious=0;
SELECT ColumnOne, ColumnTwo, ColumnThree
FROM (
SELECT ColumnOne, ColumnTwo.
@VColumnThree:=ColumnThree as CColumnThree,
(CASE
WHEN @isFirstRow=1 THEN 0
ELSE @VColumnThree-@ColumnThreeValuePrevious
END) as ColumnThree,
@ColumnThreeValuePrevious:=@VColumnThree,
@isFirstRow:=0
FROM DBTABLE ) Diff
END
Thanks and Regards
Durai Velan C