order by desc with distinct

[tamilselvan]

Try this:

select * from
( select /*+ no_merge */
distinct invoicenumber
from invoices i
where hnum='2222222' )
order by invoicenumber desc ;

Tamil