Posted by thomas.naegeli on 11/09/06 08:48

Hi all,

i'd appreciate if anyone could tell me how to select the last filled
row of a table before a given timestamp (date).

E.g. if the timestamp has date 20061101 i need to select the row with
the timestamp right before the given one. Eg if I the last filled row
before 20061101 has timestamp 20061025 (but of course I dont know which
timestamp it is), how could i code this in db2 sql to select it?

thanx a lot, help is appreciated
regards, thomas

[Back to original message]