Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with order when selecting
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
![]() |
![]() |