Re: Order by with partition
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>
- Date: Thu, 11 May 2006 12:27:20 +0200 (CEST)
Hi,
if you only need to distinct between the partitions you may use the build
in function DBMS_MVIEW.PMARKER
something like ?
select DBMS_MVIEW.PMARKER(rowid), max(column), min(column)
from your_table
group by DBMS_MVIEW.PMARKER(rowid);
To identify the partition use additional max(partition_key_column) or
max(some transformation of the partition key column) dependent of your
partitioning schema.
Regards,
Jaromir
> Hi,
>
> can we use order by or group by on clause on partition?
.com/go/onm00200636ave/direct/01/
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
