Unanswered: Days difference between consecutive dates
I have a database table which contains a datefield and a device number. For each device there are many date entries. I want to calculate the days difference between each pair of consecutive dates for each device. Can any help me on how to write a query for this without doing programming ?