|
|
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
Navigation:
[Reply to this message]
|