Count rows

sql

SELECT COUNT(*) AS row_count
FROM users;

Explanation

COUNT(*) includes rows regardless of NULL values.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Aggregation and Grouping

Aggregate values per group.

Open In sheetsqlsame section

Aggregate by more than one dimension.

Open In sheetsqlsame section

Apply conditions after aggregation.

Open In sheetsqlsame section

Calculate summary metrics.

Open In sheetsqlsame section

Return all columns from a table.

Return rows matching an exact value.