capypad
0 day streak
sql / beginner
Snippet

Aggregate Functions: COUNT

The COUNT() function returns the number of rows that matches a specified criterion. Using (*) counts all rows in the orders table.

snippet.sql
sql
1
2
SELECT COUNT(*)
FROM orders;
Breakdown
1
SELECT COUNT(*)
An aggregate function that calculates the total number of rows.