select
asset_info,month_year,
sum(incident_total) total_cnt
from
reoccuring_incident
where
asset_info in (
select asset_info from
(
select asset_info,month_year,
sum(incident_total) total_cnt
from reoccuring_incident
where
to_date(month_year,'MON-YYYY') = 'DEC-2009'
GROUP BY asset_info,month_year
order by total_cnt desc
)
where ROWNUM <= :P501_P1_NUMBER_OF_ROWS)
and to_date(month_year,'MON-YYYY') between add_months(to_date(:P501_START_DATE,'Mon-yyyy'),-3) and to_date(:P501_START_DATE,'Mon-yyyy')
group by asset_info,month_year


for the above query following result shows :

uctvd618 - UNIX Server Oct-09 34
Sep-09 10
Total: 44
uctvp618 - UNIX Virtual Dec-09 33
Nov-09 14
Total: 47
usctap0288 - Windows Server Dec-09 9
Nov-09 61
Oct-09 11
Sep-09 9
Total: 90


How to sort "Total : " as desc? ie 90,47,44

Regards,
Raj