SQL · Aggregate functions

total()

Like sum() but returns 0.0 instead of NULL when there are no rows. SQLite only.

sqlRunnable example sql course

Syntax

total(expression)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT total(minutes) AS minutes FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.