select from partition table

[marist89]

select count(*) from emp partition (sal_jan2000) will get the info from one partition.