O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-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 22

The Quantile Function

“There is flattery in friendship.”

– William Shakespeare

Table of Contents Chapter 22 – The Quantile Function

The Quantile Function and Syntax

A Quantile Example

A Quantile Example using DESC Mode

QUALIFY to find Products in the top Partitions

QUALIFY to find Products in the top Partitions Sorted DESC

QUALIFY to find Products in the top Partitions Sorted ASC

QUALIFY to find Products in top Partitions with Tiebreaker

Using Tertiles (Partitions of Four)

How Quantile Works

The Quantile Function and Syntax

The syntax for the Quantile function

QUANTILE (<partitions>, <column-name> ,<sort-key> [DESC | ASC]) [QUALIFY QUANTILE (<column-name>) {< | > | = | <= | >=} <number-of-rows>]

A Quantile is used ...

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