COUNT

An aggregate function returning the number of qualifying rows or non-NULL expression values.

What is COUNT in a relational database?

COUNT — An aggregate function returning the number of qualifying rows or non-NULL expression values.

SELECT customer_id, COUNT(*) AS order_count
FROM purchase_order
GROUP BY customer_id;

Level: Apprentice · More Database terms at this level

Updated September 27, 2026