Re: Select/Group by/Order by question

> How about:
>
>     select  to_char(mtrantime,'mm-dd hh AM') as datetime,
>     to_char(mtrantime,'AM') as sort_field,
>     count(*) as tot from memtran
>     group by sort_field, datetime
>     order by sort_field, datetime;
>
> Then ignore the sort_field column?

I usually don't like to send managers reports with data labeled
'ignore this column'.  :-)

With Tom's help, I found a solution.
--
Mike Nolan