O'Reilly logo

Tera-Tom Genius Series - Oracle SQL by Leona Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15 – Statistical Aggregate Functions

“You can make more friends in two months by becoming interested in other people than you will in two years by trying to get other people interested in you."

- Dale Carnegie

Numeric Manipulation Functions

image

The functions above are often used for algebraic, trigonometric, or geometric calculations.

The Stats Table

image

Above is the Stats_Table data in which we will use in our statistical examples.

The STDDEV_POP Function

Syntax for using STDDEV_POP:

STDDEV_POP(<column-name>)

SELECT STDDEV_POP(col1) AS SDPCol1 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required