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