I need to send a SQL query to a database that tells me how many rows there are in a table. I could get all the rows in the table with a SELECT
Some database management products provide database statistics like table sizes, but it can also be done using straight SQL.