Re: sorting multiple columns

A copy of this was sent to h0444vcs_at_rz.hu-berlin.de (if that email address didn't require changing) On Thu, 29 Jul 1999 15:08:45 GMT, you wrote:

>Dear Participants,
>
>I have the following 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 15:20:55
>bernd 22-MAY-1999 17:36:03
>bernd 23-MAY-1999 00:04:17
>myra 23-MAY-1999 06:54:57
>
>The table should be sorted by name and day. The desired output appears
>like :
>
>NAME TIMESTAMP
>----- --------------------
>bernd 22-MAY-1999 13:25:25
>bernd 22-MAY-1999 13:33:21
>bernd 22-MAY-1999 17:36:03
>myra 22-MAY-1999 13:25:57
>myra 22-MAY-1999 15:20:55
>bernd 23-MAY-1999 00:04:17
>myra 23-MAY-1999 06:54:57
>

ummm -- that looks to be sorted by DATE and then NAME, not NAME and then DAY.

 Order by trunc(timestamp), name

will order by the date (not by time within the date) and then within a date by name.

>ORDER BY didn't help me on. I tried the following :
>
>SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD' ;
>
>Session altered.
>
>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.
>
>Does someone of you know, how I can get to the desired output ?
>Your help will be greatly appreciated !
>
>Markus
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 29 1999 - 10:57:16 CDT