Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sorting tables by multiple columns
Have you tried?:
SELECT NAME, TIMESTAMP from SORT
ORDER BY trunc(TIMESTAMP),NAME,TIMESTAMP;
This will display your name column first, but it will be sorted by TIMESTAMP. The trunc function groups the data by day (midnight).
I would call my table something other than "SORT".
Markus Banach <h0444vcs_at_rz.hu-berlin.de> wrote in message news:933152217.6924_at_www.remarq.com...
> 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 Sun Aug 01 1999 - 17:59:15 CDT