Re: Problem with order when selecting

From: Ed Stevens <nospam_at_noway.nohow>
Date: Thu, 08 Jul 2004 08:58:50 -0500
Message-ID: <ankqe0lbo96elq4ddakf90gqet46h692q6@4ax.com>

On Wed, 7 Jul 2004 22:18:00 +0000 (UTC), rupa_at_firemail.de (Roman Klesel) wrote:

>
>Dear SQL hackers,
>
>I would like to do the following:
>
>select
> to_char(first_time),
> count(first_time)
>from v$log_history
> group by to_char(first_time)
> order by first_time
>
>Unfortunately this does not work.
>However when I:
>
>order by to_char(first_time)
>
>I don't get the order I want.
>
>Can some one please show me how this is ment to work!
>
>Thanks in advance.
>
>Roman Klesel

Explain "does not work". What are you getting? What are you expecting/wanting to get? Some spooled output might be helpful. Received on Thu Jul 08 2004 - 08:58:50 CDT