How to subtract two values fetched from table of same colomn ?

[jyoti.doddagoudar]

I'm printing a report in which i need to fetch previous and current value from the same 

 

colomn of the table and subtract those values and print it.

 

1.I m not getting how to fetch previous and current value from the same colomn

 

2.how to store fetched values using variables and to perform subtraction on them.

 

Info:Data type of colomn field used in table is Integer

 

Please Help me

[ajinkya_c]

Hi,

This type of requrement i think should be handle at etl side where we can use previous and current record easily or you may need to use stored procedure for that.

Thanks,

Ajinkya