Re: Order by with partition

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/
>

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