Partition Name wise Row Count of a partition table

Database

Partition Name wise Row Count of a partition table

Hi Guys,

Need help of partition table.

How to find partition_name,count(*) from a partition table.

Each Partition wise row count and row count in No Partition.

Thanks in advance,

Kamal

2 REPLIES
Junior Contributor

Re: Partition Name wise Row Count of a partition table

There's no partition nyme, just a number:

select partition, count(*)
from tab
group by 1
order by 1
Fan

Re: Partition Name wise Row Count of a partition table

hi Dieter,

How do we check the counts in MLPPI table?