my apologies,
of course we have to order by packdate:

select * from (
select count(a.cmid)
from packout a
where ordernum = '11111111111'
order by packdate desc
)
where rownum =1 ;

Stefan



Oracle LazyDBA home page