sql with order a desc, b desc

[reydp]

if you dont need the order by - remove it - if you need it well you gotta keep it

I need it, in fact, the output should have the lastN.
anyway to have this optmze with HINT or any tricks?