sorting tables by multiple columns

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!