order by desc with distinct

[jmodic]

Originally posted by slimdave
Try ...

... and
      rownum > 1 )
...

That should probably read:

... and
      rownum >= 1 )
...