order by desc with distinct

[rajabalachandra]

i am sorry not to have mentioned i use
oracle 8.1.5 on win NT.

"order by 1 desc" also did not get expected result.

anything else?

thank you!

-Raja