Count number of rows in a SQL table

Question
How do I get a count of how many rows are in a table?

Answer

Syntax

select count(*) from <tablename>

Example

select count(*) from pgcontenthdr
 Collapse All    Expand All
Custom Search

MySQL Information and Resources