How to get a total number of rows available in the table?

COUNT(*) is used to count the number of rows in the table.

SELECT COUNT(*) FROM BestPageTable;