Just curious, how can I easily combine group by and order by in order to get the count(*) and sort order to work at the same time? Since I have never used the two together that would work, unless I rewrite the query using field alias etc.


1 select owner,object_type,count(*) from
2* dba_objects group by owner,object_type