SQL 2023 · Aggregation and window functions
Count rows
Count all rows, or only non-NULL values of a column with COUNT(column).
SELECT COUNT(*) FROM orders;
Official SQL 2023 documentation
More aggregation and window functions commands
- Group and total
- Filter groups
- Number rows within groups
- Compute a running total
- Rank rows
- Compare with the previous row
All aggregation and window functions commands · SQL 2023 cheatsheet