order by desc with distinct

[slimdave]

Try ...

select*
from
   (
   select distinct
      invoicenumber
   from
      invoices i
   where
      hnum='2222222' and
      rownum > 1 )
order by
   invoicenumber desc