Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Order by with partition

Order by with partition

From: Dean Paul <oracledbam_at_hotmail.com>
Date: Tue, 09 May 2006 12:47:09 -0400
Message-ID: <BAY117-F28FA564AF74AFCA2C13618D3A90@phx.gbl>


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
Received on Tue May 09 2006 - 11:47:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US