Order by with partition

From: "Dean Paul" <oracledbam@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 09 May 2006 12:47:09 -0400

Hi,

can we use order by or group by on clause on partition?
emp(last_name char(10), first_name char(20));
This table has 3 partition like p1,p2,pf.
Can I get report like ,

partition       lastname first
partition1   xx                 aaa
               dd                pppp
partition2   ll                  jujuju
               lo                  kkkkk
partitionm ij                   sdjjdfj

Thanks

_________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Order by with partition
From: Ken Naim

Re: Order by with partition
From: jaromir nemec

Order by with partition

Other related posts: