Hello,
I have a table that I was able to cout the number of rows e.g
select count(*) from emp
This emp table has been partitioned on the sal column into months. Each partition on the sal column
is called:
sal_jan2000
sal_feb2000
sal_mar2000
sal_apr2000
sal_may2000
sal_june2000,etc
My question is how do I count the number of rows from each partition? Is that possible?
If so how? Can anybody do an example?
Bookmarks