From: Woody

>

select first 1 qty from Table1 where d_mov < (select max(d_mov) from Table
1) order by d_mov desc
<

this was the solution I could have thought of, but I didn't... :(

Thank you

Duilio