O'Reilly logo

V14 Certification: Teradata SQL by Tom Coffing, Leona 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 22 – Statistical Aggregate Function

"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

The Stats Table

image

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

The KURTOSIS Function

SELECT KURTOSIS(col1) AS KofCol1

FROM Stats_Table;

KofCol1

   -1.20

The KURTOSIS function is used to return a number that represents the sharpness of a peak on a plotted curve of a probability function for a distribution compared with the normal distribution.

A high value result is referred to as leptokurtic. While ...

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