Re: a simple SELECT ?

>select * from deliveries
>where date > (select a.date from
> deliveries a
> where 9 = (select count(*) from deliveries b
> where b.id = <id>
> and b.quantity = <qty>
> and b.id = a.id and b.qty = a.qty
> and b.date > a.date)
> and a.id = <id> and a.qty = <qty>);

More simple:

select * from deliveries
where rownum<=10
order by date desc Received on Sat May 22 1999 - 10:43:06 CDT