sql - statement: building differences between data-sets
From: beyond <rudi.ramstein_at_gmx.de>
Date: 3 Aug 2004 13:17:01 -0700
Message-ID: <621ad8ac.0408031217.41fc6fc3_at_posting.google.com>
i need a sql-statement for this problem
Date: 3 Aug 2004 13:17:01 -0700
Message-ID: <621ad8ac.0408031217.41fc6fc3_at_posting.google.com>
i need a sql-statement for this problem
i ve got a table like this
ID;value
1;30 2;34 3;44
the result of sql-statement should calculate differences to
previous/other datasets like this
ID;diff
1; 30-0 2; 34-30 3; 44-34
who can solve this problem elegant? Received on Tue Aug 03 2004 - 22:17:01 CEST