469,128 Members | 1,378 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Delta between current and previous row of select


I'm new to SQL and have the following problem.
My table contains a TimeSpent value, indicating the amount of time spent for a particular task.
There is also a ChangedDate value for each change.
I have to retrieve the work done for each person during a specified period of time.
I have a query that returns all rows for which the TmeSpent field has changed during the specified period of time.
But to find the work done, I also need the TimeSpent value just before the start date of the period.
How can I get this previous value for all rows returned by the SELECT statement ?

May 12 '07 #1
0 1095

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Egor Bolonev | last post: by
2 posts views Thread by Ken Shaw | last post: by
2 posts views Thread by Tony | last post: by
3 posts views Thread by Christopher Weaver | last post: by
3 posts views Thread by b69316 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.