| Subject | second most recent value |
|---|---|
| Author | Duilio Foschi |
| Post date | 2002-04-28T14:54:25Z |
I have records like this
qty numeric (15,2)
d_mov date
If I want the most recent value of QTY, I can write
"select first 1 qty from Table1 order by d_mov desc"
However, I want the _second_ most recent QTY value.
How can I get that ?
TIA
Duilio
qty numeric (15,2)
d_mov date
If I want the most recent value of QTY, I can write
"select first 1 qty from Table1 order by d_mov desc"
However, I want the _second_ most recent QTY value.
How can I get that ?
TIA
Duilio