how to Sort subtotals
asset_info in (
select asset_info from
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
uctvp618 - UNIX Virtual Dec-09 33
usctap0288 - Windows Server Dec-09 9
How to sort "Total : " as desc? ie 90,47,44
Also month-year column shouldn't get disturbed.. ie order should by Dec,Nov,Oct,Sep.. I try to bring this report using oracle Apex..
Click Here to Expand Forum to Full Width