yes a simple select count(*) will do

if you look at the doc for the ROWCOUNT attribute you will see when it is available