O'Reilly logo

Tera-Tom Genius Series - Kognitio Architecture and 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 20 – Statistical Aggregate Functions

“Time flies like an arrow. Fruit flies like a banana.”

- Groucho Marx

The Stats Table

image

Above is the Stats table. This will be used for our statistical examples.

Numeric Manipulation Functions

image

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

Ceiling Gets the Smallest Integer Not Smaller Than X

image

Find the smallest integer not smaller than x by using the ceil command. ...

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