A solution could be :
order by name, to_char(timestamp,'yyyymmddhh24:mi:ss')
Markus Banach wrote in message <933152217.6924_at_www.remarq.com>...
>Dear Participants,
>
>I have the following problem (table) :
>
>NAME TIMESTAMP
>----- --------------------
>bernd 22-MAY-1999 13:25:25
>myra 22-MAY-1999 13:25:57
>bernd 22-MAY-1999 13:33:21
>myra 22-MAY-1999 13:34:55
>bernd 22-MAY-1999 13:36:03
>bernd 23-MAY-1999 00:04:17
>myra 23-MAY-1999 06:54:57
>
>I want to sort the table by Name (first priority) and then
>by the day (from timestamp) (sec. priority). The desired
>output should be :
>
>NAME TIMESTAMP
>----- --------------------
>bernd 22-MAY-1999 13:25:25
>bernd 22-MAY-1999 13:33:21
>bernd 22-MAY-1999 13:36:03
>myra 22-MAY-1999 13:25:57
>myra 22-MAY-1999 13:34:55
>bernd 23-MAY-1999 00:04:17
>myra 23-MAY-1999 06:54:57
>
>Using order by didn't help me on. I tried the following :
>
>SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD' ;
>SQL> select *
> 2 from sort
> 3 order by name, timestamp
> 4 /
>
>NAME TI
>----- --
>bernd 22
>bernd 22
>bernd 22
>bernd 23
>myra 22
>myra 22
>myra 23
>
>7 rows selected.
>
>Your help will be greatly appreciated !
>
>Markus
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue Aug 03 1999 - 02:24:27 CDT
