sorting multiple columns

From: <h0444vcs_at_rz.hu-berlin.de>
Date: Thu, 29 Jul 1999 15:08:45 GMT
Message-ID: <7npqpo$nf7$1@nnrp1.deja.com>

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

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. Received on Thu Jul 29 1999 - 10:08:45 CDT