How to get subtraction of two rows value

Hi Alok ,

if your table have auto increment column for that table then here is one way to do it.......

select  acc2.Amount-acc1.Amount from account acc1 (nolock)
                     inner join Account acc2 (nolock)
                    on acc1.AccountID=acc2.AccountID-1

Note:- i have considered here AccountID is autoincrement column by 1

Thanks,

Pravin.