On Sun, 28 Apr 2002 16:54:25 +0200, Duilio Foschi wrote:

>
> If I want the most recent value of QTY, I can write
>
> "select first 1 qty from Table1 order by d_mov desc"
>

Did you try

select first 1 skip 1 qty
from Table1
order by d_mov desc

Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase