Count number of rows in partitions

1 2 3 4 5 6 7 8

SELECT table_name, partition_name, high_value, num_rows FROM SYS.ALL_TAB_PARTITIONS where table_name = 'SMSC_CDR_MT' and num_rows != 0 ORDER BY partition_name;