It will be like 1-2, 2-3, 3-4,....

Where 1 is the recent date value.

It will be in descending order

Hi,

I have a table which has date column, and name of equipments in other columns. Difference means, consider if the data is,

9/12/2008 4:10:00 PM 40694.684

9/12/2008 4:20:00 PM 40728.62

I need...

Hi all,

Please reply me. Atleast , tell me how to write query to get the difference between columns of two different rows.