SQL · Aggregate functions

variance()

Sample variance. PostgreSQL; most engines use a different name.

sqlRunnable example sql course

Syntax

variance(expression)

Example

Open in the lab

-- PostgreSQL
-- SELECT variance(minutes) FROM lessons;

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