COUNT

Returns the number of rows.

Syntax

COUNT column_name FROM table_name;